How to use if contains with similar words
I want to use if contains to find a word and classify it
The problem I have is they are to similar it will always Classify it as A and not B.
the description is to long for Has or just a regular if Statement.
=IF(CONTAINS("EOR", description@row), "A", IF(CONTAINS("BOR", description@row), "A", IF(CONTAINS("CBOR", description@row), "B", IF(CONTAINS("CEOR", description@row), "B"))))
or similar if you had to classify apple as group A and Apples as group B
Answers
-
Switch your arguments. A nested IF stops running as soon as it hits the first "true" statement. If you switch it so that CBOR comes first, it will output "B" if CBOR is found and will only move on to looking for BOR if CBOR is not found at all.
-
That worked would I be able to add on an AND So a CBOR BOR then a CBOR AND a BOR
-
I'm not sure I follow.
Help Article Resources
Categories
Check out the Formula Handbook template!