How I set up as logical test if my range has to be >=2 but <5

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I tried to use the formula "IF" to find different rates, one rate is if the #
is >= 2 but <5 and give me the error, please help me
 
One way:

=IF(AND(A1>=2,A1<5),rate1,rate2)

or, if you have three rates:

=IF(A1<2,rateA,IF(A1<5, rateB, rateC))
 
I'm not sure of the problem that you are getting at but if cell A1 has to be
less than 5 and greater than or equal to 2 then try

=IF(AND(A1>=2,A1<5),"","OUT OF RANGE")

nsnjlacm wrote in message
 
You must log in or register to reply here.

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

Excel lookup 2
Complex Look Up (amended) 2
Find Nearest Date 2
=IF(I2="",IF(F3>0,F3,""),IF(F3>0,(F3+1)*(I2+1)-1,"")) ERROR?? 0
How do I set up a Dynamic Named Ranges in Excel 2007 7
IF...payment rates 3
Logical Test for a value in a named list? 10
I need help with Numbers on Mac 0

Back
Top