How to use if contains with similar words

sstelmack

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

sstelmack

That worked would I be able to add on an AND So a CBOR BOR then a CBOR AND a BOR

Paul Newcome

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.

sstelmack

That worked would I be able to add on an AND So a CBOR BOR then a CBOR AND a BOR

Paul Newcome

I'm not sure I follow.