If Function
Maybe this is what you want then...
=IF(OR(AI3="A",AND(AI3<"A",AH3<1,OR(AL3="ZMO",AL 3="USMC"))),0,1)
although most would probably prefer to write it like this...
=IF(OR(AI3="A",AND(AI3<"A",AH3<1,OR(AL3={"ZMO"," USMC"}))),0,1)
--
Rick (MVP - Excel)
"Lizz45ie" wrote in message
...
Sorry for the confusion. AL3 can equal USMC or ZMO. I want to know how
do I
include the AL3="USMC" in the formula if AL3="USMC"? I tried all three of
the suggested formulas, I got #Value! error.
"Rick Rothstein" wrote:
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.
|