tRY...
IF(Or(AI3="A",And(AI3<"A",AH3<1,AL3="ZMO"),And(A I3<"A",AH3<1,AL3="USMC")),0,1)

By just adding the AL3="USMC", you are saying 'if AL3 = ZMO and USMC.
Obviously, it can't be both at the same time.

--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Lizz45ie" wrote:

I am trying to add another criteria to a "IF function" that isn't working.
My current IF statement is:

IF(Or(AI3="A",And(AI3<"A",AH3<1,AL3="ZMO")),0,1)

this formula works fine but when I added AL3="USMC" to the end of the
formula it no longer returns the expected result. What do I need to add to
the formula so that it returns an answer if AL3="USMC" also. Any help is
appreciated.