=IF(A1=0,0,IF(A1<500,"non
target",IF(A1<1500,"low",IF(A1<3500,"medium","high "))))
because your sequence is "logical"you can use a simple "if",because it moves
to the next argument as soon as the previous one is not true. You may or may
not need the initial if( a1 is o argument,it will display high if cell a1 is
empty or 0 without it

--
paul
remove nospam for email addy!



"Larry" wrote:

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