Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
AnonymousHi, I have a doubt in the Gratuity formula(Last basic X 15 / 26 X No of years) if 26 would be no of working days in a month, then how should we calculate if any organisation has workings of 22 days and salary calculation is for 30 Days.( Take an example IT/ITES companies)?
From India, undefined
AnonymousCan someone assist me please?
I need to calculate gratuity for our employees and criteria is
Basic salary * 7 days if years of service is 1 to 3 years
Basic salary * 14 days if years of service is 3.1 to 4.99 years
Basic salary * 21 days if years of service is more than 4.99 to 5 years
Basic salary * 30 days if years of service is more than 5.1 to above
Using IF function in excel
From United Arab Emirates, undefined