A kind of leave called commuted leave is credited half the half pay leave (another leave) every year. While commuted leave is credited maximum 30 in a service period, half pay leave is credited 60 in a service period (15 every year). Now if A1 = Half Pay Leave Credit, B1=Commuted Leave Credit and C1=Commuted Leave Availed, which excel formula has to be used to calculate the Commuted Leave Credit in B1? Please help...
https://www.dropbox.com/s/2pmrofd8w7...EAVE.xlsx?dl=0
https://www.dropbox.com/s/2pmrofd8w7...EAVE.xlsx?dl=0
Last edited by a moderator: