Re: Gratuity Formula In Excel Format - ZIP Download

My name is jitendra I am working in company almost 9.8 months how can calculate my gratuity please calculate my gratuity and email me my email id

My name is jitendra I am working in company almost 9 years 8 months my basic salary is 7200 how can calculate my gratuity please calculate my gratuity and email me my email id

one of my employee's date of joining is 02/10/2009 & date of leaving is 31/03/2016. kindly verify the year of gratuity year.

Hi, I have a doubt in the Gratuity formula(Last basic X 15 / 26 X No of years) if 26 would be no of working days in a month, then how should we calculate if any organisation has workings of 22 days and salary calculation is for 30 Days.( Take an example IT/ITES companies)?

Can someone please share the exact formula with explanations 1) for limited contract and 2) unlimited contract and how is gratuity calculated from probation to 1 year form 2 to 3 years and from 3 to 5 years and so on ! Urgent please

Can someone assist me please?
I need to calculate gratuity for our employees and criteria is
Basic salary * 7 days if years of service is 1 to 3 years
Basic salary * 14 days if years of service is 3.1 to 4.99 years
Basic salary * 21 days if years of service is more than 4.99 to 5 years
Basic salary * 30 days if years of service is more than 5.1 to above
Using IF function in excel
Thanks

Thanks for information. information is very useful.

HI
Now a days most of the companies work only 22 days in a month. in this case employee will get more Gratuity. Is the 26 is common for all or will it differ as per company?
Please give a clarity on this subject.

Yeah, but I still don't quite understand how to calculate years of paid work. In slope 3 feel the rhythm of the pulse-pounding soundtrack that amplifies every twist and turn