Display text based on a numeric range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
One More:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert numerals 11
Inserting Dashes 1
Post my named ranges in column A 10
Selection based on partial input 1
Display diff text based numbers in another cell 1
Display entire number in cell 3
show different text in cell based on range of #s in other cell 1
Number displayed as text difficulties 4

Back
Top