Using IF, OR Formula to Return a Value
I have a sheet that I want to return a value of 1 or 0 if EITHER of two possible drop-down menu items are selected. This formula I tried is returning an Incorrect Argument Set:
=IF([Safety Plan Status]2 = "Accepted", 1, 0, IF(OR([Safety Plan Status]2 = "N/A - No Onsite Labor", 1, 0)))
I am sure it is in my syntax somewhere, but I am stumped. Thanks
Help Article Resources
Check out the Formula Handbook template!