"IF" "AND" Statement to give 3 different answers

ok, I have the following formula Which I would like to add a third option, essentially "AR" could also equal "Z" However, If "AR" does equal "Z" then the answer must also be "Z"

Please Login or Register  to view this content.

I thought the following would work but it's not quite right

Please Login or Register  to view this content.

I have uploaded an example sheet, the above code is located in column "S"

Any help would be much appreciated

Try this:

=IF(BG3="", IF(AR3="Z", "Z", IF(OR(AR3={"Y","A"}),"Y","")), "")

You dont quite make it clear what you want to achieve but IFS isnt a function to start with!

I assume BG4 has to ="" or cell will contain ""

then depending on "Y", "A", "Z" you will want to look up another value

so perhaps

=IF(BG4="",CHOOSE(1+SUM((AR4={"Y","A","Z"})*{1,2,3}),"","Y","A","Z"),"")

Originally Posted by AllenMead

Thanks JBeaucaire Spot on.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.