Salary Slip Format Excel Formula

Share Your Knowledge Salary Calculator. Ms excel Salary calculator format helps you to calculate individuals salary. It also very helpfull to manage a Salary pay Slip. In a firm or small company where the number of employees are upto 5. Its totally Excel Logical Function If Function based application which reduce energy time to calculate salary or prepare salary slip. Example Salary Calculation Use of IF Function. This is a simple salary slip in Excel with general format you may use for your purposes. If you are small business owners where you are running your business with a. New Revised Basic Pay Scale Chart 2016 For Government Employees Grade 01 to 22. Muhammad Farooq. Ms excel Salary calculator format helps you to calculate individuals salary. It also very helpfull to manage a Salary pay Slip. In a firm or small company where the. Aqua Data Studio 12 License Key there. All About Microsoft Excel Project management Templates. Format of Delivery Schedule Template in Excel November 28, 2017 Pay Stub Template Excel Canada. T5L3GKrT8hA/UeQyNEi38vI/AAAAAAAAA20/tseXX8RdRXg/s640/Simple%2BSalary%2BSlip%2BFormat%2BWithout%2BDeductions.JPG' alt='Salary Slip Format Excel Formula' title='Salary Slip Format Excel Formula' />Respected all, Please send a pay slip format in excel with inbuilt formula for PT,PF ESIC calculations. Warm Regards, PRABHU prabhunathsharmayahoo. Please send me Bonus forms A,B,C,Din excel format with example calculation. PART 1. To calculate salary 1st open Excel 2. View Excel Wrap Text http www. Employee Code No keep it same like in picture Name keep it same like in picture Designation keep it same like in picture Basic Salary keep it same like in picture Now calculate some ALLOWANCES based on assumption House Rent Allowance HRA If 1. Rs 2. 00. 0, than HRA will Rs 2. If 1. 0 of basic salary is lower than Rs 2. HRA will 1. 0 of Basic Salary Formula IFD21. Install Xen Server On Usb Flash. D2. 0. write formula in E2 cell drag formula to E2. Dearness Allownace DA DA is 2. Basic Salary Formula D2. F2 cell drag formula to F2. Medical Allowance MA Executives get MA Rs 1. Officers get MA Rs 7. Assistants get MA Rs 5. Formula IFC2Excutives,1. IFC2Officers,7. G2 cell drag formula to G2. PART 3 Gross Salary Total of Basic HRA DA MA Formula SUMD2 G2. H2 cell drag formula to H2. Professional Tax Upto 5. Formula IFH2lt 5. IFH2lt 1. 00. IFH2lt 1. I2 cell drag formula to I2. Salary Paid Per Month Gross Salary Professional Tax Formula H2 I2 write formula in J2 cell drag formula to J2. Annual Salary Salary Paid Per Month 1. Formula J2. 2 write formula in K2 cell drag formula to K2. Income Tax Upto 1. Formula IFK2lt 1. IFK2lt 1. 50. J2 1. IFK2lt 2. 50. K2 1. K2 2. 50. 00. 0. L2 cell drag formula to L2. Net Salary Payable Annual salary income tax Formula M2 M2 Download This Example Salary File, Excel 2.