Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Fesk
 
Posts: n/a
Default 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   Report Post  
Domenic
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formulas dealing with text data Bagia Excel Worksheet Functions 6 June 20th 05 10:29 PM
center text in a formula result Wilma Excel Worksheet Functions 2 June 9th 05 06:24 PM
Change Text to a number Brooks W. Excel Worksheet Functions 1 April 28th 05 05:20 AM
Change Text to a number jennifer Excel Worksheet Functions 1 April 27th 05 08:47 PM
inserting data from a row to a cell, when the row number is specified by a formula in a cell [email protected] New Users to Excel 2 January 6th 05 08:18 AM


All times are GMT +1. The time now is 09:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"