Can anyone send me a format in Excel for gratuity calculation as per U.A.E with IF conditions? The rule is as follows:
Gratuity Calculation Rules
1st year: 7 days' salary of basic
2nd year: 14 days' basic salary
3rd year: 21 days' basic salary
3rd to 5 years: 21 days' basic salary x number of years up to 5
After 5 years: 30 days' basic salary x number of years served
All conditions should be included in one formula in one column. Can anyone please help?
From United Arab Emirates, Dubai
Acknowledge(4)
Amend(0)
5Gratuity Calculation Rules
1st year: 7 days' salary of basic
2nd year: 14 days' basic salary
3rd year: 21 days' basic salary
3rd to 5 years: 21 days' basic salary x number of years up to 5
After 5 years: 30 days' basic salary x number of years served
All conditions should be included in one formula in one column. Can anyone please help?
From United Arab Emirates, Dubai
Acknowledge(4)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Payment of Gratuity Act, 1972 & The Rules.ppt
Gratuity calculation.doc
FORM - F (TN Payment of Gratuity Rules, 1973).xls