As AL3 can not equal both "ZMO" and "USMC" at the same time, you probably
need to insert another OR function. Also, it is redundant to check for
AI3="A", and AI3<
"A".

=IF(OR(AI3="A",AND(AH3<1,OR(AL3="USMC",AL3="ZMO") )),0,1)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"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.