Thread: commissions by range
View Single Post
  #2  
Old November 26th, 2005, 04:29 PM posted to microsoft.public.excel.worksheet.functions
rsenn
external usenet poster
  
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