Display text based on a numeric range
 

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

Display text based on a numeric range
 

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

Display text based on a numeric range
 

=if(A1<1,"Too Low",if(A1<4,"Low",if(A1<7,"Medium",if(A1<10,"High ","Too
High"))))

--
Regards,
Tom Ogilvy


"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

Display text based on a numeric range
 

One Mo

=IF(OR(A1="",A1<1,A19),"",CHOOSE(TRUNC((A1-1)/3)+1,"Low","Medium","High"))

--
Regards,
Tom Ogilvy


"Tom Ogilvy" wrote in message
...
=if(A1<1,"Too Low",if(A1<4,"Low",if(A1<7,"Medium",if(A1<10,"High ","Too
High"))))

--
Regards,
Tom Ogilvy


"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