| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| display a range of editible cells based on specific in another cel | Excel Discussion (Misc queries) | |||
| WEEKDAY() function: display TEXT not numeric weekday | Excel Discussion (Misc queries) | |||
| Display leading zeros in numeric value without converting to text | Excel Discussion (Misc queries) | |||
| Find and Return Numeric Label based on (Numeric Value) Criterion | Excel Worksheet Functions | |||
| Excel 2007 Display value based on values in another column range | Excel Worksheet Functions | |||
Linear Mode
