(Another) If statement question. I am trying to categorize the data I have through using a content analysis type formula. What I want to do is to identify the keywords within the small extracts, and place them into categories such as "Driver breaking related". However, it is flagging some of the data as true, when it should be marking it as false. This screenshot should illustrate this.
My code is:
=IF(AND(ISERROR(FIND("Brake",A2)),ISERROR(FIND("brake",A2)),ISERROR(FIND("brakes",A2))),TRUE,FALSE). 
Aucun commentaire:
Enregistrer un commentaire