Thread: Need to assign new codes
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
  
Posts: 1,388
Default 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 With QuoteReply With Quote