Hi,
I am trying to accomplish on below Scenarios of employee present days in Formula on Cell ' I10'. but fail to do so.
Scenario #1
IF Present Days are 6 minimum then Employee are allowed to get Two Paid Leave and this should add +1 in 6 present days on cell I10 (Earned) final result after +1 will be 7 Earned days .
Scenario #2
IF Present Days are 12 (6+6) minimum then Employee are allowed to get Two Paid Leave and this should add +1 in 12 present days on cell I10 (Earned) final result after +1 will be 13 Earned days .
Scenario #3
IF Present Days are 18 (6+6+6) minimum then Employee are allowed to get Thre Paid Leave and this should add +1 in 18 present days on cell I10 (Earned) final result after +1 will be 19 Earned days .
and sooon.....
any help/support on this will appreciated
Best,
Bookmarks