View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mat mat is offline
external usenet poster
 
Posts: 37
Default 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