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 to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Gratuity calculation.doc
Salary Calculation format .xls