If(AND formula help please

[ferde]

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","")

 

[Asgharpearl]

Please write this formula

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

 

[ferde]

Thank you ...works great