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

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" <[email protected]> wrote in message
news:[email protected]...
>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

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

--
Regards,
Tom Ogilvy


"swheeler" <[email protected]> wrote in message
news:[email protected]...
> 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

One More:

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

--
Regards,
Tom Ogilvy


"Tom Ogilvy" <[email protected]> wrote in message
news:[email protected]...
> =if(A1<1,"Too Low",if(A1<4,"Low",if(A1<7,"Medium",if(A1<10,"High","Too
> High"))))
>
> --
> Regards,
> Tom Ogilvy
>
>
> "swheeler" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>