One way .. try in say, B1:

=IF(A1="","",IF(AND(A1=0,A1<=150),"OK",
IF(AND(A1=151,A1<=300),"Check",
IF(AND(A1=301,A1<=500),"Under","")))

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"carl" wrote in message
...
I am trying to write a formula that will look at a value and if that value
is
between 0 and 150 return "OK", if between 151 and 300. return "Check", or
if
between 301 and 500 return "Under"

Thank you in advance.