Thread: commissions by range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rsenn
 
Posts: n/a
Default commissions by range

Assume the sales data is in cell A1.


=IF(A1<=100,0.005*A1,IF(A1<=150,0.5+0.0075*(A1-100),0.875+0.01*(A1-150)))


--
rsenn
------------------------------------------------------------------------
rsenn's Profile: http://www.excelforum.com/member.php...o&userid=29050
View this thread: http://www.excelforum.com/showthread...hreadid=488360

Reply With QuoteReply With Quote