Hover over image for animation

Calculate the commission on sales.

`=A2*B2`

where `A2`

is the rate of commission (entered as a percentage)

`B2`

is the amount of sales

Calculate the holiday pay.

`=0.175*B3`

0.175 for 17.5% holiday loading

where `B3`

is 4 weeks normal pay

Calculate net pay following deductions from gross pay.

`=B1-B2`

where `B1`

is gross pay and `B2`

is the deductions