Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
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, 94 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 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, 23 views)

Please Login To Add Reply

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2020 Cite.Co™