Leave Availed Calculation formula reqd
- Thread starter webmax
- Start date
The basic rule applies: Leave availed can not be more than the opening balance, right?
If yes then there is no meaning of adjusting leaves bcoz the employee should be prompted about Zero leaves in the account (SL,PL,CL,etc) and they themselves should check and apply proper type of leave.
By the way.... Half Day leave is not allowed in ur office???
If yes then there is no meaning of adjusting leaves bcoz the employee should be prompted about Zero leaves in the account (SL,PL,CL,etc) and they themselves should check and apply proper type of leave.
By the way.... Half Day leave is not allowed in ur office???
I'm not a genius like others here but I just tried to make a "Nest" 
Chk the file attached...
Chk the file attached...
Thx for the honor, but honestly I'm not Genius...... I'm just GS
By the way plz correct the formula in cell Q3 as:
Same shall be updated in remaining cells of column Q.
By the way plz correct the formula in cell Q3 as:
Code:
=IF(R3=0,IF(AND(K3<0,L3<=0,M3<=0),0,IF(AND(K3<0,K3+L3<=0),SUM(K3:M3),M3)),0)
All my formuals and logic was destroyed when I got a though:
What if there is a value in Leave Availed (LOP)?????
What should be the case if (for some reason) employee wants to apply for LOP even if SL,PL,CL is still balance?
Then Leave Availed (LOP) should be added in Output Leave Availed(LOP)..... but now, nesting became a League of Vampires... and obviously I'm the victim
What if there is a value in Leave Availed (LOP)?????
What should be the case if (for some reason) employee wants to apply for LOP even if SL,PL,CL is still balance?
Then Leave Availed (LOP) should be added in Output Leave Availed(LOP)..... but now, nesting became a League of Vampires... and obviously I'm the victim
Check the attached file....
I've taken the rule that "If employee availed LOP then that LOP will NOT be adjusted in remaining leaves and the LOP will be added in "Leaves Availed(LOP)".
I've taken the rule that "If employee availed LOP then that LOP will NOT be adjusted in remaining leaves and the LOP will be added in "Leaves Availed(LOP)".
Abusive language will not be tolerated.
NARAYANK991
Excel Ninja
Hi Shahul ,
I think a lot of time has passed since you originally posted your problem ; the member who helped you in resolving part of your problem is not replying ; if others have to pitch in , it will take some effort to go through the entire thread and work out what is required.
Can you please start a new thread , specify your problem in greater detail , and upload your latest workbook ? You need not start from the beginning ; just list down what your current problem is in more detail.
We will take it from there.
Narayan
I think a lot of time has passed since you originally posted your problem ; the member who helped you in resolving part of your problem is not replying ; if others have to pitch in , it will take some effort to go through the entire thread and work out what is required.
Can you please start a new thread , specify your problem in greater detail , and upload your latest workbook ? You need not start from the beginning ; just list down what your current problem is in more detail.
We will take it from there.
Narayan
SirJB7
Excel Rōnin
Sep 2nd:
Maybe the lack of further replies lays in the 18 days that you took to confirm gsvirdi if what he have posted worked or not. Follow NARAYANK991's suggestion and place a link to this topic in your new thread.
Regards!
PS: Next time, be considered with people who helped you and replay sooner, it'd help to get acknowledge on the efforts and time spent. Thank you.
Sep 2nd:
Sep 20th:
Hi, webmax!
Maybe the lack of further replies lays in the 18 days that you took to confirm gsvirdi if what he have posted worked or not. Follow NARAYANK991's suggestion and place a link to this topic in your new thread.
Regards!
PS: Next time, be considered with people who helped you and replay sooner, it'd help to get acknowledge on the efforts and time spent. Thank you.