Peo, you are Fantastic!!!.
I understand some of what you did, but can you explain, in simple terms,
what is occurring in this formula?
Thanks
LB
"Peo Sjoblom" wrote:
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
|