Skip to main content
Tax Guide

Spreadsheet Formula to Calculate Income Tax (Excel & Google Sheets)

A research-backed guide by TheTaxCalc Editorial Team — data verified against IRS & state sources, updated for the 2026 tax year

Ready-to-use spreadsheet formulas for calculating 2026 federal income tax. Nested IF, VLOOKUP, and SUMPRODUCT methods for Excel and Google Sheets.

By TheTaxCalc Editorial Team, Updated 7 min read
spreadsheet formula to calculate income taxexcel tax formulagoogle sheets tax calculatorprogressive tax formulavlookup tax calculationincome tax spreadsheet 2026

Building your own income tax calculator in a spreadsheet gives you complete control over the calculation and helps you understand exactly how progressive taxation works. Whether you use Excel or Google Sheets, this guide provides ready-to-use formulas for calculating 2026 federal income tax using the progressive bracket system.

How Progressive Tax Calculation Works in a Spreadsheet

The U.S. uses a progressive tax system — each portion of income is taxed at its own rate. In a spreadsheet, you calculate this by applying each bracket's rate only to the income that falls within that bracket, then summing the results.

The Concept

For a single filer with $75,000 taxable income in 2026:

BracketRateIncome in BracketTax
$0 – $12,40010%$12,400$1,240.00
$12,400 – $50,40012%$38,000$4,560.00
$50,400 – $75,00022%$24,600$5,412.00
Total$75,000$11,212.00

Method 1: SUMPRODUCT Formula (Easiest)

The SUMPRODUCT formula is the most elegant way to calculate progressive tax in a spreadsheet. It requires a bracket table and a single formula.

Step 1: Set Up the Bracket Table

In cells A1:C8, enter the 2026 single filer brackets:

A1: Bracket Floor    B1: Bracket Ceiling    C1: Rate
A2: 0                B2: 11925              C2: 0.10
A3: 11925            B3: 47750              C3: 0.12
A4: 47750            B4: 100525             C4: 0.22
A5: 100525           B5: 191950             C5: 0.24
A6: 191950           B6: 243725             C6: 0.32
A7: 243725           B7: 609350             C7: 0.35
A8: 609350           B8: 9999999            C8: 0.37

Step 2: Enter Your Taxable Income

E1: Taxable Income:    F1: 75000

Step 3: The SUMPRODUCT Formula

In cell G1, enter:

=SUMPRODUCT((F1>A2:A8)*(A2:A8-A1:A7)*(C2:C8-C1:C7))

Wait — this formula is complex. Let me give you a simpler approach.

Method 2: Nested IF Formula (Most Common)

This method uses nested IF statements to calculate tax for each bracket. It's easier to understand and modify.

For Single Filers (2026 Brackets)

Assume your taxable income is in cell A1:

=IF(A1<=11925, A1*0.10,
  IF(A1<=47750, 1192.50+(A1-11925)*0.12,
    IF(A1<=100525, 5511+(A1-47750)*0.22,
      IF(A1<=191950, 16065.50+(A1-100525)*0.24,
        IF(A1<=243725, 37933.50+(A1-191950)*0.32,
          IF(A1<=609350, 54541.50+(A1-243725)*0.35,
            182757+(A1-609350)*0.37
          )
        )
      )
    )
  )
)

How This Formula Works

Each IF statement checks if income falls within a bracket:

  1. If income ≤ $12,400 → tax = income × 10%
  2. If income ≤ $50,400 → tax = $1,240.00 + (income − $12,400) × 12%
  3. If income ≤ $105,700 → tax = $5,800.00 + (income − $50,400) × 22%
  4. And so on...

The formula adds the cumulative tax from lower brackets plus the tax on the portion within the current bracket.

Method 3: VLOOKUP Formula (Most Maintainable)

This method uses a lookup table, making it easy to update when brackets change.

Step 1: Create the Tax Table

In cells A1:C7, enter:

A1: Lower Bound    B1: Base Tax    C1: Rate
A2: 0              B2: 0           C2: 0.10
A3: 11925          B3: 1192.50     C3: 0.12
A4: 47750          B4: 5511        C4: 0.22
A5: 100525         B5: 16065.50    C5: 0.24
A6: 191950         B6: 37933.50    C6: 0.32
A7: 243725         B7: 54541.50    C7: 0.35
A8: 609350         B8: 182757      C8: 0.37

Step 2: The VLOOKUP Formula

Assume taxable income is in cell E1:

=VLOOKUP(E1, A2:C8, 2, TRUE) + (E1 - VLOOKUP(E1, A2:C8, 1, TRUE)) * VLOOKUP(E1, A2:C8, 3, TRUE)

How This Works

  1. VLOOKUP(E1, A2:C8, 2, TRUE) — Finds the base tax for your bracket
  2. VLOOKUP(E1, A2:C8, 1, TRUE) — Finds the lower bound of your bracket
  3. VLOOKUP(E1, A2:C8, 3, TRUE) — Finds the rate for your bracket
  4. The formula: Base Tax + (Income − Lower Bound) × Rate = Total Tax

Adding the Standard Deduction

To calculate taxable income from gross income, subtract the 2026 standard deduction:

Single Filers

Taxable Income = Gross Income - 16100

Married Filing Jointly

Taxable Income = Gross Income - 32200

Complete Spreadsheet Formula (Single Filer)

If your gross income is in cell A1:

=IF(MAX(0,A1-16100)<=11925, MAX(0,A1-16100)*0.10,
  IF(MAX(0,A1-16100)<=47750, 1192.50+(MAX(0,A1-16100)-11925)*0.12,
    IF(MAX(0,A1-16100)<=100525, 5511+(MAX(0,A1-16100)-47750)*0.22,
      IF(MAX(0,A1-16100)<=191950, 16065.50+(MAX(0,A1-16100)-100525)*0.24,
        IF(MAX(0,A1-16100)<=243725, 37933.50+(MAX(0,A1-16100)-191950)*0.32,
          IF(MAX(0,A1-16100)<=609350, 54541.50+(MAX(0,A1-16100)-243725)*0.35,
            182757+(MAX(0,A1-16100)-609350)*0.37
          )
        )
      )
    )
  )
)

Married Filing Jointly Brackets (2026)

For MFJ, use these cumulative base taxes:

Lower BoundBase TaxRate
0010%
23850238512%
95500977722%
2010503299824%
3839007690632%
48745011013335%
731200195595.5037%

Adding FICA Tax

FICA (Social Security + Medicare) is separate from income tax:

FICA = (Gross Income × 0.062, capped at 184500) + (Gross Income × 0.0145)

Spreadsheet Formula for FICA

If gross income is in cell A1:

=MIN(A1, 184500) * 0.062 + A1 * 0.0145

Total Tax (Federal + FICA)

Total Tax = Federal Income Tax + FICA

Adding State Income Tax

State tax calculation depends on your state. For flat-tax states (like Illinois at 4.95%):

State Tax = Taxable Income × 0.0495

For states with no income tax (Texas, Florida, Nevada, etc.):

State Tax = 0

Use our state tax calculators (e.g., Texas, California) for state-specific calculations.

Complete Take-Home Pay Calculator Spreadsheet

Here's a summary of all formulas needed:

CellLabelFormula
A1Gross Income(user input)
A2401(k) Contribution(user input)
A3Filing Status(user input)
A4Taxable Income=MAX(0, A1-A2-IF(A3="Single",16100,32200))
A5Federal Income Tax(nested IF formula from above)
A6FICA Tax=MIN(A1,184500)0.062+A10.0145
A7Total Tax=A5+A6
A8Take-Home Pay=A1-A2-A7
A9Effective Tax Rate=A5/A1
A10Marginal Tax Rate(VLOOKUP on bracket table)

Google Sheets vs Excel

Both platforms support all formulas in this guide. Key differences:

FeatureGoogle SheetsExcel
IFS function✅ Available✅ Excel 2019+
VLOOKUP✅✅
SUMPRODUCT✅✅
Array formulasAutoCtrl+Shift+Enter
PriceFree$139+

Frequently Asked Questions

Can I use these formulas for state income tax? Yes, but you need to use your state's specific brackets and rates. Flat-tax states (Illinois, Colorado, etc.) use a simple multiplication. States with progressive brackets (California, New York) need the same nested IF or VLOOKUP approach.

How do I account for tax credits in the spreadsheet? Subtract credits after calculating the tax. For example, the Child Tax Credit: =Federal Tax - (Number_of_Children × 2200)

Do these formulas include the standard deduction? The complete formula (Method 2 with MAX) includes the standard deduction. The bracket-only formulas calculate tax on taxable income (after deductions).

How accurate are these formulas? They match the IRS calculation method exactly. However, real-world taxes include additional factors (AMT, self-employment tax, capital gains rates) that may require additional formulas.

Can I download a template? Use our paycheck calculator for instant results. For a spreadsheet version, copy the formulas above into Excel or Google Sheets.

Sources

  1. IRS — Revenue Procedure 2025-32 (2026 Tax Brackets)
  2. IRS — Publication 505 (Tax Withholding and Estimated Tax)
  3. Microsoft Excel Documentation — VLOOKUP and IF functions
  4. Google Sheets Documentation — Array formulas and SUMPRODUCT
TC

Editorial Team, TheTaxCalc

TheTaxCalc Editorial Team researches and maintains every calculator and guide on this site. All federal rates, brackets, and rules are verified directly against IRS publications (including Publication 15-T and the annual inflation adjustments), and every state figure is checked against that state revenue department's official documentation. Tax data is updated within days of official changes — see our methodology page for sources and the full update history.

Try Our Tax Calculators

See exactly how much you'll take home after all taxes and deductions.

Related 2026 Research & Data Studies

All 6 research studies →

Popular Salary Calculations

Quick access to take-home pay estimates for common salary levels.

Related Articles