| 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. | 1081 views Knowledgebase Categories Popular Discussions |
| Discuss problems with your peers without getting into personal specifics. Access to years of discussion data available to everyone at no cost. |