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
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:
- If income ≤ $11,925 → tax = income × 10%
- If income ≤ $47,750 → tax = $1,192.50 + (income − $11,925) × 12%
- If income ≤ $100,525 → tax = $5,511 + (income − $47,750) × 22%
- 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
-
VLOOKUP(E1, A2:C8, 2, TRUE)— Finds the base tax for your bracket -
VLOOKUP(E1, A2:C8, 1, TRUE)— Finds the lower bound of your bracket -
VLOOKUP(E1, A2:C8, 3, TRUE)— Finds the rate for your bracket - 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 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)
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:
| 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
- Paycheck Calculator — Instant federal + state tax calculation
- 2026 Tax Brackets — Complete bracket reference
- OASDI Tax Explained — Social Security tax details
- OBBBA Tax Calculator — 2026 tax law comparison
Sources
- IRS — Revenue Procedure 2025-25 (2026 Tax Brackets)
- IRS — Publication 505 (Tax Withholding and Estimated Tax)
- 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)