One way, assume the number in question is in cell A1


=IF(A1="","",VLOOKUP(A1,{0,"Non
Target";500,"Low";1500,"Medium";3500,"High"},2))

I assumed that the number can't be less than zero

--
Regards,

Peo Sjoblom


"Larry" wrote in message
...
I have to evaluate a single number in a single cell and return a value
based
on that number. How do I build a formula to do the following?
If the number is < 500, I need to return "Non-Target"
If the number is = 500 but < 1500, I need to return "Low"
If the number is = 1500 but < 3500, I need to return "Medium"
If the number is = 3500, I need to return a value of "High"

How do I build this formula