Hello Forum
I need a function to do the following:
I need to calculate basic wage and sales commission
Basic Wage
Sales payment per order
Sales
1 - 10 10
11 - 20 15
21 - 30 20
31 + 25
Example 1
Basic wage £0
Sales 26 units at £20 per sale = £520
Total wage £520
Example 2
Basic wage £100
Sales 25 units at £20 per sale = £500
Total wage £600
This is what I need to show as the result.
Hope someone can help
--
Carauto
------------------------------------------------------------------------
Carauto's Profile:
http://www.excelforum.com/member.php...o&userid=29500
View this thread:
http://www.excelforum.com/showthread...hreadid=492131