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!
Best Answers
-
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
-
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")))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
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")))
Michael
-
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
-
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")))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives