Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to assign new codes
Hi,
I have a database of clients with revenue range from less than $ 25,000 to 300,000 +. I need to assign each client a segment based on their revenue. Less than $ 25000 to be E $ 25000 to 50,000 to be D $ 50000 to 150,000 to be C $ 150000 to 300,000 to be B $ 300,000 and above to be A Regards Mat |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to assign new codes
I think this formula will do what you want...
=LOOKUP(A1,{0,25000,50000,150000,300000},{"E","D", "C","B","A"}) Adjust the A1 reference accordingly. Rick "Mat" wrote in message ... Hi, I have a database of clients with revenue range from less than $ 25,000 to 300,000 +. I need to assign each client a segment based on their revenue. Less than $ 25000 to be E $ 25000 to 50,000 to be D $ 50000 to 150,000 to be C $ 150000 to 300,000 to be B $ 300,000 and above to be A Regards Mat |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to assign new codes
Hi Rick,
It worked perfectly. Thanx Mat "Rick Rothstein (MVP - VB)" wrote: I think this formula will do what you want... =LOOKUP(A1,{0,25000,50000,150000,300000},{"E","D", "C","B","A"}) Adjust the A1 reference accordingly. Rick "Mat" wrote in message ... Hi, I have a database of clients with revenue range from less than $ 25,000 to 300,000 +. I need to assign each client a segment based on their revenue. Less than $ 25000 to be E $ 25000 to 50,000 to be D $ 50000 to 150,000 to be C $ 150000 to 300,000 to be B $ 300,000 and above to be A Regards Mat |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to assign new codes
Hi,
Try this, where A1 contains the client's revenue. Change to suit. =IF(A1300000,"A",IF(A1=150000,"B",IF(A1=50000," C",IF(A1=25000,"D","E")))) Regards - Dave. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with codes | Excel Discussion (Misc queries) | |||
Codes | Excel Discussion (Misc queries) | |||
VB Codes | Excel Discussion (Misc queries) | |||
ZIP CODES | Excel Worksheet Functions | |||
Assign numerical values to text codes | Excel Worksheet Functions |