Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
number range returning a text value
Hi,
I would like to be able to return a specific text when a number is added to a column. For example, if a number is inputted and it falls within the range "1-5", then the text field "low" is returned. If however "6" is inputted, the result would give the text "Medium", and if "10" is inputted, the returning text field is "High" Thanks for any help |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
number range returning a text value
Jason
Try: =IF(A1<6,"Low",IF(A19,"High","Medium")) George Gee "jason" wrote in message ... Hi, I would like to be able to return a specific text when a number is added to a column. For example, if a number is inputted and it falls within the range "1-5", then the text field "low" is returned. If however "6" is inputted, the result would give the text "Medium", and if "10" is inputted, the returning text field is "High" Thanks for any help |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
number range returning a text value
Try this.........
=LOOKUP(A1,{1,6,10},{"low","medium","high"}) Vaya con Dios, Chuck, CABGx3 "jason" wrote: Hi, I would like to be able to return a specific text when a number is added to a column. For example, if a number is inputted and it falls within the range "1-5", then the text field "low" is returned. If however "6" is inputted, the result would give the text "Medium", and if "10" is inputted, the returning text field is "High" Thanks for any help |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
number range returning a text value
Create a lookup table, containing the possible values and there respective
responses, say 1 - 10, and in an adjacent cell whether it should return Low, Medium or High or whatever else., Name this range something like Criterion. Where you want the result to display, enter the following formula: =VLOOKUP(<cell ref of the cell containing the value, eg A3,Criterion,2,FALSE). That will give you the correct result every time. "jason" wrote: Hi, I would like to be able to return a specific text when a number is added to a column. For example, if a number is inputted and it falls within the range "1-5", then the text field "low" is returned. If however "6" is inputted, the result would give the text "Medium", and if "10" is inputted, the returning text field is "High" Thanks for any help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Change number in Text Box in Excel | Excel Discussion (Misc queries) | |||
Match function...random search? | Excel Worksheet Functions | |||
Returning a value for a number in a range | Excel Discussion (Misc queries) | |||
What defines number or text | New Users to Excel |