Gratuity Calculation Formula In Excel

Hi,Nowadays, most companies work only 22 days in a month. In this case, employees will receive more Gratuity. Is the 26th common for all companies, or will it differ based on the company?Please provide clarity on this subject.

Hi Venkat,If an employee worked for 5 years and 8 months, then you have to consider 6 years as the number of completed years of service.Formula for Calculation: Last Basic / 26 X 15 X 6.

Can someone please share the exact formula with explanations for 1) limited contract and 2) unlimited contract? Also, how is gratuity calculated from probation to 1 year, from 2 to 3 years, and from 3 to 5 years, and so on! This is urgent, please.

Please clarify how to calculate the number of years worked for gratuity.For example, if someone has worked for 5.5 years, how many years should be considered for calculation and payment of gratuity? What is the exact concept behind this calculation? Please provi...

My name is Jitendra. I have been working in the company for almost 9 years and 8 months. My basic salary is 7200\. How can I calculate my gratuity? Please calculate my gratuity and email me at my email id.

Good Morning!Your question pertains to the calculation of professional tax (P.T.) based on salary slabs in Maharashtra, specifically for those earning above Rs 5000/- and Rs 10000/-.Here's a simple way to calculate it:1\. 💰 If an employee's monthly salary is ab...

=IF(C2>=12000, "200", IF(C2>=9000, "150", IF(C2>=6000, "80", "0")))