IF AND help!
 

What's the formula for:

If A1<=2 or A11 then B1
If A2 then C1
If A<=1 then 0

I assume it'll be an extensions of this formula which is missing the
A12 part:

IF(AND(A1<=2,A11),B1,0)

Thanks a million!


--
acebrown
------------------------------------------------------------------------
acebrown's Profile: http://www.excelforum.com/member.php...o&userid=36640
View this thread: http://www.excelforum.com/showthread...hreadid=568107

IF AND help!
 

"acebrown" wrote in
message ...

What's the formula for:

If A1<=2 or A11 then B1
If A2 then C1
If A<=1 then 0

I assume it'll be an extensions of this formula which is missing the
A12 part:

IF(AND(A1<=2,A11),B1,0)

=IF(A12,C1,IF(A11,B1,0))
assuming that your first condition was intended to be "and", not "or", and
that where you said A in your 2nd & 3rd conditions you intended A1.
--
David Biddulph