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 E13 = Half Pay Leave Credit, H13=Commuted Leave Credit and I13=Commuted Leave Availed, which excel formula has to be used to calculate the Commuted Leave Credit in H13 as in the following link? Please help...
https://www.dropbox.com/s/2pmrofd8w7xbd7v/COMMUTED LEAVE.xlsx?dl=0
https://www.dropbox.com/s/2pmrofd8w7xbd7v/COMMUTED LEAVE.xlsx?dl=0