Gratuity Calculation Formula In Excel Pakistan May 2026

So, the employee’s gratuity amount would be PKR 416,667.

Here’s how you can calculate the gratuity in Excel: Value Basic Salary 50,000 Length of Service 20 Gratuity Rate 0.005 (⁄ 2 of 1%) Using the formula: gratuity calculation formula in excel pakistan

\[ ext{Gratuity} = rac{ ext{Basic Salary} imes ext{Length of Service} imes ext{Gratuity Rate}}{12} \] So, the employee’s gratuity amount would be PKR

Calculating Gratuity in Pakistan: A Step-by-Step Excel Formula Guide** gratuity calculation formula in excel pakistan