Calculate Gratuity in excel -Employee eligible under Gratuity act 1972-Gratuity calculation in excel

U Excel in Excel

My Channel

GRATUITY CALCULATION
"What is Gratuity
Gratuity is a benefit which is payable under the Payment of Gratuity Act 1972. 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 =
Average Salary * # of service year * (15/26)"

Datedif function for calculating number of service year by comparing date of joining and last working day(resignation date)
=DATEDIF(C5,D5,"Y")
Sum function to add Basic Salary and Dearness Allowance
Average monthly salary = Basic Salary + Dearness Allowance
Datedif function to calculate number of months
=DATEDIF(C5,D5,"YM")
Employee eligible for gratuity
Gratuity amount formula
Use of if Function in gratuity calculation
Use if sum function in gratuity calculation
Gratuity calculation in excel
how to calculate Gratuity in excel


Excel VBA Online Training courses
Excel VBA Beginner Tutorial
#ExcelTips
#ExcelTutorial
#Excel
MS Excel 2020/2016/2013/2010/2007
Excel step-by-step tutorial
ms excel
excel tutorial
excel formulas
microsoft excel (software)
learn excel
microsoft excel
learn ms excel
Basic Excel Formulas and Functions For Beginners
Excel world
Excel data entry work
Excel formula number
excel test for Job interview
Excel interview questions
excel shortcut keys in mobile
excel movies
excel vba
excel macro
ms excel full course in Hindi
MS excel everything
MS excel new features
Excel in Kannada, Exel in Tamil, Excel in Telugu, Excel in Malayalam

[anandvijayu]

Please provide rule for rounding off the final Gratuity amount..

[Peace.sacrifice]

What ups if employee completed exact, 6 year 6 months