Your question is not stated clearly enough. What exactly do you mean by
"returns an answer if AL3="USMC" also"... what does "also" apply to... the
OR or the AND part? Or is it an AND condition coupled with the OR? These are
the three possibilities as I see it. If you want it OR'ed with the other OR
conditions...

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

or if you want it AND'ed with the other AND conditions...

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

or if you want it AND'ed with the OR condition...

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

One of these should be what you want (depending on how you meant "also" to
be interpreted).

--
Rick (MVP - Excel)


"Lizz45ie" wrote in message
...
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.