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

Find more posts tagged with

Formulas

IF(

Accepted answers

sstelmack

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

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.