Calculation
Excel formula
Hover over image for animation
Commission | # gomaths.net/4221 User submitted, thanks to Simon Job
Calculate the commission on sales.
=A2*B2
where A2 is the rate of commission (entered as a percentage)
B2 is the amount of sales
Holiday Pay | # gomaths.net/4220 User submitted, thanks to Simon Job
Calculate the holiday pay.
=0.175*B3
0.175 for 17.5% holiday loading
where B3 is 4 weeks normal pay
Net Pay | # gomaths.net/4216 User submitted, thanks to Simon Job
Calculate net pay following deductions from gross pay.
=B1-B2
where B1 is gross pay and B2 is the deductions
