Gratuity Calculation In Excel

Описание: My Channel
   / @uexcelinmsoffice4323  

What is Gratuity
"Gratuity is a sum of money paid by an employer to an employee for services rendered
in the company "

Gratuity Eligibility Criteria
1. An employee retires
2. An employee resigns after working for 5 years with a single employer
3. An employee passes away or suffers disability due to illness or accident

Gratuity Calculation Formula =
Monthly Salary * # of service year * (15/26)


"Date Of
Joining" "Last Working
Day" "Basic
Salary" "Dearness
Allowance" "Monthly
Salary" "Number Of
Years" "Gratuity
Amount"
27-Apr-15 03-Aug-24 23000 2760 25760 9 133754