ExcelBanter - Change number to text formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Change number to text formula (https://www.excelbanter.com/excel-worksheet-functions/42958-change-number-text-formula.html)

Fesk

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

Domenic

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

All times are GMT +1. The time now is 07:24 AM.