Hi

you can use an IF function
=IF(A1<=3,"Low",IF(A1<=6,"Medium",IF(A1<=9,"High", "")))
or
=LOOKUP(A1,{-1E+300;0.00000000000001;4;7;10},{"";"Low";"Medium" ;"High";""})

where the number you are testing for is in cell A1
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"swheeler" wrote in message
...
I need to display text based on the number that is displayed in a cell.
for
instance, if the number is between 1-3, I need to display "Low"; between
4-6,
I need to display "Medium"; and between 7-9 I need to display "high". How
can I set this up to work? thanks