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

  • Lara Homewood
    Answer ✓

    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
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    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!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Answers

  • Brian Campbell
    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")))

    Michael

  • Lara Homewood
    Answer ✓

    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
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    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!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com