If(AND formula help please
 

Can someone help me with a formula.

if A1 is between -20 to -30 the result is "falls20-30" otherwise leave
blank. I am using the the following formula with no success.

=IF(AND(A1=-20,A1=-30),"falls20-30","")

If(AND formula help please
 

Try this:

=IF(AND(A1<=-20,A1=-30),"Falls 20-30","")

--
Biff
Microsoft Excel MVP


"ferde" wrote in message
...
Can someone help me with a formula.

if A1 is between -20 to -30 the result is "falls20-30" otherwise leave
blank. I am using the the following formula with no success.

=IF(AND(A1=-20,A1=-30),"falls20-30","")

If(AND formula help please
 

Try this

=IF(AND(A1<=-20,A1=-30),"falls20-30","")

-20 is bigger than -30 and we tend to forget that....

If this post helps click Yes
---------------
Jacob Skaria


"ferde" wrote:

Can someone help me with a formula.

if A1 is between -20 to -30 the result is "falls20-30" otherwise leave
blank. I am using the the following formula with no success.

=IF(AND(A1=-20,A1=-30),"falls20-30","")

If(AND formula help please
 

Please write this formula

=IF(AND(A1<=-20,A1=-30),"falls 20-30","")

"ferde" wrote:

Can someone help me with a formula.

if A1 is between -20 to -30 the result is "falls20-30" otherwise leave
blank. I am using the the following formula with no success.

=IF(AND(A1=-20,A1=-30),"falls20-30","")

If(AND formula help please
 

Thank you ...works great

"ferde" wrote:

Can someone help me with a formula.

if A1 is between -20 to -30 the result is "falls20-30" otherwise leave
blank. I am using the the following formula with no success.

=IF(AND(A1=-20,A1=-30),"falls20-30","")