Click on cell E2 and enter the following formula:
A common point of confusion in Pakistan is the "5-year rule." Under the , gratuity is strictly payable if service is less than 5 years but gratuity calculation formula in excel pakistan
=SUM(IF(DATEDIF(Joining,TODAY(),"Y")>=1, (Basic * DATEDIF(Joining,TODAY(),"Y") * 7)/26, 0)) Click on cell E2 and enter the following
The mathematical formula is:
Create a new Excel workbook. Label the columns as follows (recommended for Pakistani payroll): (Basic * DATEDIF(Joining