DEV Community

masamesoo11
masamesoo11

Posted on Originally published at thetaxcalc.com

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

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:

Bracket Rate Income in Bracket Tax
$0 – $11,925 10% $11,925 $1,192.50
$11,926 – $47,750 12% $35,825 $4,299.00
$47,751 – $100,525 22% $27,250 $5,995.00
Total $75,000 $11,486.50

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
Enter fullscreen mode Exit fullscreen mode

Step 2: Enter Your Taxable Income

E1: Taxable Income:    F1: 75000
Enter fullscreen mode Exit fullscreen mode

Step 3: The SUMPRODUCT Formula

In cell G1, enter:

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

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
          )
        )
      )
    )
  )
)
Enter fullscreen mode Exit fullscreen mode

How This Formula Works

Each IF statement checks if income falls within a bracket:

  1. If income ≤ $11,925 → tax = income × 10%
  2. If income ≤ $47,750 → tax = $1,192.50 + (income − $11,925) × 12%
  3. If income ≤ $100,525 → tax = $5,511 + (income − $47,750) × 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
Enter fullscreen mode Exit fullscreen mode

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)
Enter fullscreen mode Exit fullscreen mode

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
Enter fullscreen mode Exit fullscreen mode

Married Filing Jointly

Taxable Income = Gross Income - 32200
Enter fullscreen mode Exit fullscreen mode

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
          )
        )
      )
    )
  )
)
Enter fullscreen mode Exit fullscreen mode

Married Filing Jointly Brackets (2026)

For MFJ, use these cumulative base taxes:

Lower Bound Base Tax Rate
0 0 10%
23850 2385 12%
95500 9777 22%
201050 32998 24%
383900 76906 32%
487450 110133 35%
731200 195595.50 37%

Adding FICA Tax

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

FICA = (Gross Income × 0.062, capped at 184500) + (Gross Income × 0.0145)
Enter fullscreen mode Exit fullscreen mode

Spreadsheet Formula for FICA

If gross income is in cell A1:

=MIN(A1, 184500) * 0.062 + A1 * 0.0145
Enter fullscreen mode Exit fullscreen mode

Total Tax (Federal + FICA)

Total Tax = Federal Income Tax + FICA
Enter fullscreen mode Exit fullscreen mode

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
Enter fullscreen mode Exit fullscreen mode

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

State Tax = 0
Enter fullscreen mode Exit fullscreen mode

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:

Cell Label Formula
A1 Gross Income (user input)
A2 401(k) Contribution (user input)
A3 Filing Status (user input)
A4 Taxable Income =MAX(0, A1-A2-IF(A3="Single",16100,32200))
A5 Federal Income Tax (nested IF formula from above)
A6 FICA Tax =MIN(A1,184500)*0.062+A1*0.0145
A7 Total Tax =A5+A6
A8 Take-Home Pay =A1-A2-A7
A9 Effective Tax Rate =A5/A1
A10 Marginal Tax Rate (VLOOKUP on bracket table)

Google Sheets vs Excel

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

Feature Google Sheets Excel
IFS function ✅ Available ✅ Excel 2019+
VLOOKUP ✅ ✅
SUMPRODUCT ✅ ✅
Array formulas Auto Ctrl+Shift+Enter
Price Free $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.

Related Resources

Sources

  1. IRS — Revenue Procedure 2025-25 (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

This guide was originally published on TheTaxCalc.

Run your exact numbers for free — no signup, no email required:

Top comments (0)