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