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

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

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

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.