Kindly find the attached leave balance calculation and instruction given in the file.
I require the formula for the same.
Hi,
Half day is allowed. but if they have leave so they can adjust the same in the leave have.
=IF(R3=0,IF(AND(K3<0,L3<=0,M3<=0),0,IF(AND(K3<0,K3+L3<=0),SUM(K3:M3),M3)),0)
Hi Gs,
Ur a very very genius. i will check and confirm thanks.......
hi if the Opening Balance in SL in C3 cell as 2 it showing SL as -3 in O3 Cell.
Kindly check
If the LOP of means loss of pay though is have balance it should be comes in LOP. Because of the some reason like not inform the leave to his boss this situation will come.
hi gsthis some of the leave calculation is not doing properlyi am attaching the file and mentioned the output come like this in the column
Sep 2nd:Sorry I'm just nesting..... try now
Sep 20th:thanks gs for your continuous effort!!!!.
Will work on different combination and confirm you.
Hi, webmax!hi when then leave balance is less than SL it is not adjusting in the other leave balance