Select cell E4 and enter the formula : =IF(D4>40,40*C4+(D4-40)*1.5*C4,D4*C4)
Drag/ copy the formula from E4 up to E11.
Select cell F4 and enter the formula: =E4-(B4*90)
Drag/ copy the formula from F4 up to F11
Select cell G4 and enter the formula: =E4*$B$16
Drag/ copy the formula from G4 up to G11
Select cell H4 and enter the formula: =E4*$B$17
Drag/ copy the formula from H4 up to H11
Select cell I4 and enter the formula : =IF(F4>=689,110.85+($B$19*(F4-689)),F4*$B$18)
Drag/ copy the formula from I 4 up to I 11
Select cell J4 and enter the formula: =I4*$B$20
Drag/ copy the formula from J4 up to J11
Select cell K4 and enter the formula: =E4-G4-H4-I4-J4
Drag/ copy the formula from K4 up to K11
Select cell D12 and enter the formula: =SUM(D4:D11)
Drag/copy the formula from D12 up to K12
Save the file with your name and Upload an Excel file.
