Change number to text formula

[Guest]

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!