Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Change number to text formula
Hi
I would like to be able to type in persons age and have excel place it into a category. eg 50 to 59 would be in the 'A' category 60 to 65 would be in the 'B' category 70 and over would be in the 'c' category Hope you can make sense of this. Any help would be appreciated. Thanks Fesk |
#2
|
|||
|
|||
Try...
=LOOKUP(A1,{50,60,70},{"A","B","C"}) ....where A1 contains the person's age. Hope this helps! In article , "Fesk" wrote: Hi I would like to be able to type in persons age and have excel place it into a category. eg 50 to 59 would be in the 'A' category 60 to 65 would be in the 'B' category 70 and over would be in the 'c' category Hope you can make sense of this. Any help would be appreciated. Thanks Fesk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
center text in a formula result | Excel Worksheet Functions | |||
Change Text to a number | Excel Worksheet Functions | |||
Change Text to a number | Excel Worksheet Functions | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel |