Re: Gratuity Formula In Excel Format - ZIP Download - CiteHR
Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
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.


This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2020 Cite.Co™