Question: what is the formula to calculate gratuity in excel?
Answer: It is calculated according to this formula: Last drawn salary (basic salary plus dearness allowance) X number of completed years of service X 15/26.