multiple IF OR statement help

Hi Can get one IF OR statement but need help with multiples please...

=IF(OR(Name2 = "Alex", Name2 = "Dana",Name2="PAt"), "Jo" OR (Name2="Adi", Name2="Mal",Name2="Mark "), "Angela" OR(Name2="Sophie", Name2="Amy", Name2="Elle",Name2="Dan"), "Mary")

THANK YOU!

Find more posts tagged with

Accepted answers

Lara Homewood

Thank you Michael, unfortunately the statement you kindly wrote for me didn't work but perhaps I'll look at doing vlookup later on .. my brain is formula fried!!!

Thank you so much. Really is appreciated

Paul Newcome

Give this one a go...

=IF(OR(Name2 = "Alex", Name2 = "Dana", Name2 = "PAt"), "Jo", IF(OR(Name2 = "Adi", Name2 = "Mal", Name2 = "Mark"), "Angela", IF(OR(Name2 = "Sophie", Name2 = "Amy", Name2 = "Elle", Name2 = "Dan"), "Mary")))

All comments

Brian Campbell

Hello Lara, an alternative to this could be a vlookup or data mesh. Also it would probably be a quicker running one of those formulas and easier to tweek if necessary. If you need help with this just let me know.

I believe the formula you need is close to this if you go the initial route (see bottom). With each new group a new if statement is needed basically going like this. The logic is if any of the criteria is true then show the true statement, if not go to the next set of criteria and repeat.

=if(or(Criteria1, Criteria 2), Value if true, if(or(Criteria1, Criteria 2), value if true, if(or(Criteria1, Criteria 2), value if true, value if false)))

=IF(OR([Name2]@row= "Alex", [Name2]@row = "Dana", [Name2]@row="PAt"), "Jo", if(OR ([Name2]@row="Adi",

[Name2]@row="Mal",[Name2]@row="Mark "), "Angela", if(OR([Name2]@row="Sophie",

[Name2]@row="Amy", [Name2]@row="Elle",[Name2]@row="Dan"), "Mary", "Value if all false")))

Lara Homewood

Thank you Michael, unfortunately the statement you kindly wrote for me didn't work but perhaps I'll look at doing vlookup later on .. my brain is formula fried!!!

Thank you so much. Really is appreciated

Paul Newcome

Give this one a go...

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.