This excel is for understanding the Gratuity Calculation, which is a tentative Calculation to find the amount for Gratuity when person left from the organisation. or we say at the time of full and final settlement.
Formula :- Last Drawn Salary/26*15*No of Yrs Service.
Rules :-
1) Which consist of Minimum 5 Yrs Service as per Gratuity Act 1972. and if person complete more than 6 month , then its consists 1 Year.
2 )But the person who is minimum 4 yrs & 8 month service is consider as "0" zero years of gratuity service.
3) And if his is work for 4 Yrs & 8 Month and more but less than 5 yrs, then also he is consider as 5 yrs of services for gratuity is applicable.

From India, Pune

Attached Files
File Type: xlsx SACHIN GRATUITY FORMULA SHEET.xlsx (12.6 KB, 156 views)

Hello! What type of music do you like to listen? What about me, I like rock music, but my friend like to listen heavy metal music and I am going to write an article about the impact of metal music on the human psyche by using this great online writing service. So, fellas, if you are interested, simply click on this https://papernow.org/ website and buy your papers.
From United Kingdom, Rugby
Revised formula for error 5.6 yrs convert in 6 yrs.
From India, Pune

Attached Files
File Type: xlsx SACHIN GRATUITY FORMULA SHEET (1).xlsx (12.6 KB, 63 views)

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views using the reply box below. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone.

Please Login To Add Reply






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2021 CiteHR.Comô

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server