if cell falls within range of number (i.e. 2500 to 4999)
What do you want to happen if the value in A1 is less than 2500 or
greater than 9999?
Pete
On Aug 18, 5:17*pm, 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%
|