Hi

One way
With Basic wage in A1, number of units sold in B1
=A1+B1*10+B1*INT(B1/10)*5

Regards

Roger Govier


Carauto wrote:
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