IF AND help!

[acebrown]

What's the formula for:

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

I assume it'll be an extensions of this formula which is missing th
A1>2 part:

IF(AND(A1<=2,A1>1),B1,0)

Thanks a million

 

[David Biddulph]

What's the formula for:

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

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

IF(AND(A1<=2,A1>1),B1,0)

=IF(A1>2,C1,IF(A1>1,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.