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"
I thought the following would work but it's not quite right![]()
=IF(AND(BG3="",OR(AR3={"Y","A"})),"Y","")
I have uploaded an example sheet, the above code is located in column "S"![]()
=IFS(AND(BG4="",OR(AR4={"Y","A","Z"})),"Y","Z","")
Any help would be much appreciated
Bookmarks