Hello
I am trying to compute deduction to be made for latecoming of employees
attached sample
4 late comings are allowed as shown in B2
In excess of 4, it is calculated for every 4 and part there of
So in total 13, 4 exempted that is 13-4=9
so now this 9 spilt in multiples of 4 is 4,4 and 1
So first 4 is 100*4, next 4 is 200*4 and remaining 1 is 400*1
Bookmarks