If(AND formula help please

  • Thread starter Thread starter ferde
  • Start date Start date
F

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

nested formulas in excel using iserror and if 2
Getting a value out of a Matrix 4
Index and match formulas 1
Average of a string containing multiple values 20
Satisfying several criteria 4
Combine If/Lookup? 2
Formula to select values 1
Index & match/IF/Vlookup formula help 5

Back
Top