How To Software Calculate Net Salary Using Microsoft Excel Share Pin Email Print Ariel Skelley / Getty Images Software Spreadsheets Documents Presentations Desktop Publishing Graphic Design Databases Animation & Video by Ted French Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs. Updated June 29, 2019 A net salary formula calculates an employee's actual take-home pay in light of gross wages and relevant deductions. Collect Payroll Data Create a new workbook in Microsoft Excel, using your own pay stub or payroll remittance advice form as a guide. Populate the sheet's columns as follows: Column Value A Pay Date B Hours Worked C Hourly Rate D Positive Adjustments (e.g., reimbursements or stipends) E Negative Adjustments (e.g., voluntary payroll deductions) F Pre-Tax Deductions (e.g., insurance premiums) G Post-Tax Deductions (e.g., garnishments) H State Income Tax Rate I Local Income Tax Rate J Federal Income Tax Rate K Medicare Tax Rate L Pre-Tax Retirement Contributions M Post-Tax Retirement Contributions Because every employer is different and every state has slightly different tax rules, you'll need to identify for yourself which of your deductions and contributions are assessed before or after your taxes. Your federal tax rates may vary based on your exemptions; you can calculate your tax rates by dividing your assessed taxes against your taxable gross income from your pay stub. Calculate Net Salary Use the following formulas to calculate your net salary and other interesting financial metrics: Net Salary: =((((B*C)+D)-Sum(E+F+L)) - (((B*C)+D)-Sum(E+F+L))*H - (((B*C)+D)-Sum(E+F+L))*I - (((B*C)+D)-Sum(E+F+L))*J - (((B*C)+D)-Sum(E+F+L))*K) - G - MGross Salary: =(B*C)+DPre-Tax Salary: =(((B*C)+D)-Sum(E+F+L)) Considerations Using a formula to calculate net salary makes sense if you're trying to approximate your take-home pay. However, some situations may adversely affect your calculations: If you're paid every other week, some deductions may not apply to the third payroll in the same month. In a calendar year, there are 26 pay periods but 24 fortnights and some deductions (e.g., for health insurance) may be calculated to pull only 24 times per year.Watch your pay stub to identify which deductions are pre-tax or post-tax. Some deductions are based on a percentage of gross payroll — for example, garnishments. Continue Reading Learn Excel With This Step-by-Step Basic Tutorial How to Use Spreadsheets Formulas in MS Works Learn Excel With This Step-by-Step Basic Tutorial Open Office Calc Tutorial - Step by Step Learn What MS Excel Does Plus Did You Know Excel's DATEDIF Function Can Calculate Your Age? How to Determine a Graphic Design Hourly Rate Browse These Free PC Game Downloads How to Use the IRR Formula in Excel Are You Using Everything Your Spreadsheet Program Has to Offer? How to Make a Plot Chart in Excel How to Use the Xcopy Command in Windows What Is a Formula in Excel and How Do I Use It? COUNTIF - COUNTA Percentage Formula Learn How to Use Absolute Cell Reference in Excel Did You Know That You Can Analyze Data from the Web Using Excel?