Excel formula

Commission | #

Calculate the commission on sales.


where A2 is the rate of commission (entered as a percentage)
B2 is the amount of sales

Discount as percentage | #

Calculate discount as a percentage from sale price and discount amount.


Holiday Pay | #

Calculate the holiday pay.


0.175 for 17.5% holiday loading
where B3 is 4 weeks normal pay