Dear All,
I have doubt in Excel for Gratuity Calculation and is that we have calculated that if any one completed 5 years and 7 months, we calculated 6 year for Calculation of Gratuity and one completed 10 years and 4 months, we calculated 10 years for Calculation of Gratuity.
Now my question is that i have required exact formula for above situation.
Thank & Regards,
pm44
I have doubt in Excel for Gratuity Calculation and is that we have calculated that if any one completed 5 years and 7 months, we calculated 6 year for Calculation of Gratuity and one completed 10 years and 4 months, we calculated 10 years for Calculation of Gratuity.
Now my question is that i have required exact formula for above situation.
Thank & Regards,
pm44