if cell falls within range of number (i.e. 2500 to 4999)
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
"Susan" wrote:
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%
|