if cell falls within range of number (i.e. 2500 to 4999)

  • Thread starter Thread starter Susan
  • Start date Start date
S

Susan

I want to detetermine is a cell falls within a pre-estabished set up ranges.

Cell A1 = 4800
Such as
if quantity is 2500-4999 it should return 1.5%
if quantity is 5000-9999 it should return 1.2%

So this correct answer should return 1.5%
 
What do you want to happen if the value in A1 is less than 2500 or
greater than 9999?

Pete
 
Susan,

Format the cell with this in as percentage

=IF(AND(A1>=2500,A1<=4999),1.5%,IF(AND(A1>=5000,A1<=9999),1.2%,"Outside of
range"))

Mike
 
Back
Top