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 the A1>2 part:

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

Thanks a million!

[David Biddulph]

"acebrown" <[email protected]> wrote in
message news:[email protected]...
>
> 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.
--
David Biddulph