Your federal tax rates may vary based on your exemptions.

To calculate your tax rates, divide the assessed taxes against the taxable gross income from your pay stub.

BelowRow 2, (CellB4in this example) enterGross Salaryand pressEnter.

Employee using spreadsheet on laptop.

Ariel Skelley / DigitalVision / Getty Images

InCellC4, enter=B2*C2+D2and pressEnter.

InCellB5, enterPre-Tax Salaryand pressEnter.

InCellC5, enter=B2*C2+D2-(E2+F2+L2)and pressEnter.

Basic payroll information has been entered into Excel.

InCellB6, enterState Income Taxesand pressEnter.

InCellC6, enter=C5*H2and pressEnter.

InCellB7, enterLocal Income Taxesand pressEnter.

Entering Gross Salary into a cell in Microsoft Excel.

InCellC7, enter=C5*I2and pressEnter.

InCellB8, enterFederal Income Taxesand pressEnter.

InCell C8, enter=C5*J2and pressEnter.

Entering Gross Salary formula into a cell in Microsoft Excel.

InCellB9, enterMedicare\SS Taxesand pressEnter.

InCellC9, enter=C5*K2and pressEnter.

InCellB10, enterNet Salaryand pressEnter.

Entering Pre-Tax Salary into a cell in Microsoft Excel.

InCellC10, enter=C5-C6-C7-C8-C9-G2-M2and pressEnter.

You might want toformat the cellsin the currency format and round to two decimals for easier reading.

However, some situations may adversely affect your calculations:

Entering pre-tax salary formula into a cell in Microsoft Excel.

Entering State Income Taxes into a cell in Microsoft Excel.

Entering state income taxes formula into a cell in Microsoft Excel.

Entering Local Income Taxes into a cell in Microsoft Excel.

Entering local income taxes formula into a cell in Microsoft Excel.

Entering Federal Income Taxes into a cell in Microsoft Excel.

Entering federal income taxes formula into a cell in Microsoft Excel.

Entering Medicare\SS into a cell in Microsoft Excel.

Entering Medicare\SS formula into a cell in Microsoft Excel.

Entering Net Salary into a cell in Microsoft Excel.

Entering net salary formula into a cell in Microsoft Excel.