Can any send me a format in excel for gratuity calculation as per U.A.E with IF conditions. The Rule is as follows:
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 upto 5
after 5 years 30 days basic salary x number of years served
All condition should come in one formula in one column
Can Anyone pls help
From United Arab Emirates, Dubai
51st 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 upto 5
after 5 years 30 days basic salary x number of years served
All condition should come in one formula in one column
Can Anyone pls help
From United Arab Emirates, Dubai
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In. When a new query arises, we tap into our engaged community - sending emails to members who have contributed to similar topics - to gather valuable insights. Additionally, our extensive repository of previously answered questions ensures quick access to expert solutions.
Gratuity calculation.doc
Salary Calculation format .xls