Gratuity Calculation Excel Format UAE Rules - basic salary.. CiteFin
CiteLegal
 
HOME RISE NEW ABOUT LOGIN
Home > Finance Sectors > Accounting

Gratuity Calculation Excel Format UAE Rules

francis_fernandes18 Started The Discussion:

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

If you have any insight on this, or if you are looking for information on the same topic, please engage with this member to help add value to this discussion.
Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.
Explore Topical Knowledge Areas

Interesting Relevant Discussions

DISCUSSSION STATISTICS


1555
VIEWS

PLEASE KEEP YOUR CONDUCT PROFESSIONAL AND POLITE


3M Users, 100K+ Documents & 450K+ Discussions

Share »

Community Support & Professional Insights. Login or Register.
Email/Username     Password  

About Us - Advertise - Contact Us - RSS   On Google+  
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network