Calculation

Excel formula

Holiday Pay | # gomaths.net/4220     

Calculate the holiday pay.

=0.175*B3

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