You can calculate an estimated U.S. federal ordinary income tax in Excel by applying the 2026 progressive tax brackets to taxable income. Then calculate:
- Marginal tax rate: the rate on your next dollar of taxable income.
- Effective tax rate: estimated federal income tax divided by taxable income.
This worksheet does not automatically include tax credits, capital-gains rates, payroll taxes, self-employment tax, state tax, or every rule on a tax return. Label the result as an estimate unless your workbook accounts for all applicable items.
First, decide which federal tax rate you need
“Federal tax rate” can describe several different calculations:
| Measure | Formula | What it tells you |
|---|---|---|
| Marginal rate | Rate of the highest bracket reached | The rate on the next dollar of ordinary taxable income |
| Effective rate on taxable income | Federal income tax ÷ taxable income | Your average federal income-tax rate on taxable income |
| Effective rate on gross income | Federal income tax ÷ gross income | Your income-tax burden before deductions |
| Withholding percentage | Federal withholding ÷ wages | How much your employer withheld, not your final tax rate |
| Combined tax rate | Federal, payroll, state, and local taxes combined | Your broader tax burden |
If your taxable income reaches the 22% bracket, you do not pay 22% on every dollar. The U.S. system is progressive: each slice of income is taxed at the rate for its bracket.
Quick wins for a faster PC:
Scan for outdated or missing drivers - takes under a minuteDriver Scan →Clear out junk files and repair common Windows errorsFree Scan →Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →#1 Best Overall
![H&R Block Tax Software Deluxe + State 2025 Win/Mac [PC/Mac Online Code]](https://m.media-amazon.com/images/I/41ZQoiZKHHL._SL160_.jpg)
- Tax prep made smarter: With AI Tax Assist, you can get real-time expert answers from start to finish.
- Step-by-step Q&A and guidance
- Quickly import your W-2, 1099, 1098, and last year's personal tax return, even from TurboTax and Quicken software
- Itemize deductions with Schedule A
- Accuracy Review checks for issues and assesses your audit risk
Use the correct tax year
The examples below use 2026 tax-year ordinary federal income-tax rules. Tax year 2026 covers income earned during 2026; the return is generally filed in 2027. Brackets and deductions can change, so do not reuse these figures for another year without updating the worksheet. The IRS publishes the 2026 rate schedules in its inflation-adjustment guidance.
The 2026 ordinary rates are 10%, 12%, 22%, 24%, 32%, 35%, and 37%.
Gather the information Excel needs
A basic calculator needs:
- Tax year
- Filing status
- Taxable income
A more complete workbook can also include:
- Gross income
- Adjustments to income
- Standard or itemized deduction
- Tax credits
- Federal withholding and estimated payments
For the bracket calculation, use taxable income, not simply salary or gross income. Taxable income generally reflects applicable adjustments and deductions.
2026 federal tax brackets
Use the table matching your filing status. The thresholds below are lower limits for each bracket.
Free tools Windows power users keep installed
One-click scans. No signup required.
| Rate | Single | Married filing jointly and qualifying surviving spouse |
|---|---|---|
| 10% | $0–$12,400 | $0–$24,800 |
| 12% | Over $12,400–$50,400 | Over $24,800–$100,800 |
| 22% | Over $50,400–$105,700 | Over $100,800–$211,400 |
| 24% | Over $105,700–$201,775 | Over $211,400–$403,550 |
| 32% | Over $201,775–$256,225 | Over $403,550–$512,450 |
| 35% | Over $256,225–$640,600 | Over $512,450–$768,700 |
| 37% | Over $640,600 | Over $768,700 |
Head-of-household, married-filing-separately, and other applicable schedules have different thresholds. Use the status-specific schedules in the IRS guidance rather than adapting the single-filer table.
Build the Excel input area
For a simple single-filer worksheet, enter this layout:
Rank #2
![TurboTax Deluxe Desktop Edition 2025, Federal & State Tax Return [Win11/Mac14 Download]](https://m.media-amazon.com/images/I/41Ug1D1e2xL._SL160_.jpg)
- TurboTax Desktop Edition is download software which you install on your computer for use
- Requires Windows 11 or macOS Sonoma or later (Windows 10 not supported)
- Recommended if you own a home, have charitable donations, high medical expenses and need to file both Federal & State Tax Returns
- Includes 5 Federal e-files and 1 State via download. State e-file sold separately. Get U.S.-based technical support (hours may vary).
- Live Tax Advice: Connect with a tax expert and get one-on-one advice and answers as you prepare your return (fee applies)
| Cell | Label | Example |
|---|---|---|
| B2 | Taxable income | 100000 |
| B3 | Filing status | Single |
| B4 | Estimated federal income tax | Formula |
| B5 | Marginal tax rate | Formula |
| B6 | Effective tax rate | Formula |
Format B2 and B4 as currency or numbers. Format B5:B6 as percentages. For a reusable workbook, add data validation to B3 so users can select a supported filing status from a dropdown.
Calculate estimated tax with a nested IF formula
For a single filer, put this formula in B4 when B2 contains taxable income:
Windows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstallCrashes, No Sound, or Screen Glitches?
Random freezes, missing sound and display glitches usually trace back to one bad driver. Find and replace yours safely.Free scan · under a minute=IF(B2<=12400,B2*10%,
IF(B2<=50400,1240+(B2-12400)*12%,
IF(B2<=105700,5800+(B2-50400)*22%,
IF(B2<=201775,17966+(B2-105700)*24%,
IF(B2<=256225,41024+(B2-201775)*32%,
IF(B2<=640600,58448+(B2-256225)*35%,
192979.25+(B2-640600)*37%))))))The base-tax amount in each branch represents the tax accumulated in earlier brackets. For example, income above $50,400 starts with $5,800 of tax, then applies 22% only to the amount above $50,400. Microsoft documents the behavior and syntax of Excel’s IF function and discusses the maintenance problems of very long nested formulas.
With $100,000 in B2, the result is $16,712.
Calculate the marginal tax rate
Put this formula in B5:
=IF(B2<=12400,10%,
IF(B2<=50400,12%,
IF(B2<=105700,22%,
IF(B2<=201775,24%,
IF(B2<=256225,32%,
IF(B2<=640600,35%,37%))))))For $100,000 of taxable income, B5 returns 22%. That means the next dollar of ordinary taxable income is generally taxed at 22%; it does not mean the entire $100,000 is taxed at 22%.
Calculate the effective federal tax rate
Put this formula in B6:
=IF(B2=0,0,B4/B2)For the example:
=16712/100000The result is 16.712%, which displays as 16.71% when formatted to two decimal places. Keep the result numeric if you will use it in another calculation. A formula such as =TEXT(B4/B2,"0.00%") produces formatted text instead.
Understand the example
| Taxable-income slice | Rate | Tax |
|---|---|---|
| $0–$12,400 | 10% | $1,240 |
| $12,400–$50,400 | 12% | $4,560 |
| $50,400–$100,000 | 22% | $10,912 |
| Total | $16,712 |
Thus, the marginal rate is 22%, while the effective rate on taxable income is 16.712%. Crossing into a higher bracket is not a tax cliff: only the dollars above the threshold enter the higher bracket.
Recommended Free Tools
Rank #3
![H&R Block Tax Software Premium & Business 2025 Win [PC Online code]](https://m.media-amazon.com/images/I/41QUtTaIoiL._SL160_.jpg)
- Premium: Windows 10 or higher and Business: Windows 11
- Tax prep made smarter: With AI Tax Assist, you can get real-time expert answers from start to finish.
- Quickly import your W-2, 1099, 1098, and last year's personal tax return, even from TurboTax and Quicken software
- Five free federal e-files and unlimited federal preparation and printing
- Free e-file included for most business forms
Use a table-driven formula for a reusable workbook
Nested IF formulas are easy to see but difficult to update. A bracket table is more maintainable because you can replace the year’s thresholds and rates without rewriting the calculation.
In E3:F9, enter the following 2026 single-filer table:
| Cell range E3:E9: lower limit | Cell range F3:F9: rate |
|---|---|
| 0 | 10% |
| 12400 | 12% |
| 50400 | 22% |
| 105700 | 24% |
| 201775 | 32% |
| 256225 | 35% |
| 640600 | 37% |
Keep the lower-limit column sorted in ascending order. Then calculate tax with:
=SUMPRODUCT(($B$2>$E$3:$E$9)*($B$2-$E$3:$E$9)*$F$3:$F$9)This calculates the tax on each bracket slice and adds the results. At exactly a threshold, the newly entered slice contributes zero, so the result remains correct. Microsoft’s SUMPRODUCT documentation explains the matching-array requirement.
The Tool Desk
Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →To return the marginal rate in current Excel versions, use:
=XLOOKUP(B2,$E$3:$E$9,$F$3:$F$9,,,-1)The final -1 tells XLOOKUP to return an exact match or the next smaller threshold. XLOOKUP is available in Microsoft 365, Excel for the web, Excel 2021, Excel 2024, and other current versions, but is not natively available in Excel 2016 or Excel 2019 according to Microsoft’s lookup-function reference.
Rank #4
![TurboTax Home & Business Desktop Edition 2025, Federal & State Tax Return [Win11/Mac14 Download]](https://m.media-amazon.com/images/I/41g5u0+-GVL._SL160_.jpg)
- TurboTax Desktop Edition is download software which you install on your computer for use
- Requires Windows 11 or macOS Sonoma or later (Windows 10 not supported)
- Recommended if you are self-employed, an independent contractor, freelancer, small business owner, sole proprietor, or consultant
- Includes 5 Federal e-files and 1 State via download. State e-file sold separately. Get U.S.-based technical support (hours may vary)
- Live Tax Advice: Connect with a tax expert and get one-on-one advice and answers as you prepare your return (fee applies)
For older Excel versions, use:
=LOOKUP(B2,$E$3:$E$9,$F$3:$F$9)Approximate lookup requires ascending thresholds. With VLOOKUP, use the approximate-match setting carefully; Microsoft explains the relevant behavior in its VLOOKUP documentation.
Add filing-status support
Do not use the single-filer table for every taxpayer. Create a separate threshold-and-rate table for each supported status, such as:
- Single
- Married filing jointly
- Married filing separately
- Head of household
- Qualifying surviving spouse, where applicable
You can then use a status dropdown and select the corresponding table with modern functions such as FILTER, CHOOSECOLS, or XLOOKUP. For a beginner-friendly workbook, separate visible tables are easier to audit than one compressed formula. Named ranges can also work; INDIRECT is possible but makes formulas less transparent and harder to audit.
Calculate taxable income from gross income
The safest basic version asks for taxable income directly. If you want an expanded worksheet, use separate inputs:
| Item | Example |
|---|---|
| Gross income | $120,000 |
| Adjustments | $0 |
| Standard or itemized deduction | $16,100 |
| Taxable income | $103,900 |
If gross income is in B2, adjustments in B3, and deductions in B4, use:
=MAX(0,B2-B3-B4)The 2026 standard deduction is $16,100 for single and married-filing-separately taxpayers, $24,150 for head of household, and $32,200 for married filing jointly, according to the IRS 2026 inflation-adjustment announcement. Do not assume the standard deduction applies automatically: itemizing and other adjustments may produce a different result.
Best Value
![TurboTax Business Desktop Edition 2025, Federal Tax Return [Win11 Download]](https://m.media-amazon.com/images/I/41DGgZMFxXL._SL160_.jpg)
- TurboTax Desktop Edition is download software which you install on your computer for use
- Requires Windows 11 or macOS Sonoma or later (Windows 10 not supported)
- Recommended if you have a partnership, own an S or C Corp, Multi-Member LLC, manage a trust or estate, or need to file a separate tax return for your business
- Includes 5 Federal e-files. Business State forms sold separately via download. Get U.S.-based technical support (hours may vary).
- Prepare and file your business or trust taxes with confidence
Handle credits, withholding, and other taxes separately
A bracket formula estimates preliminary ordinary federal income tax. It is not automatically a complete tax return.
- Credits: Child-related, education, foreign-tax, and other credits may reduce tax after the preliminary calculation. Refundable and nonrefundable credits work differently.
- Qualified dividends and long-term capital gains: Some investment income uses preferential rates rather than ordinary brackets.
- Alternative Minimum Tax: A separate AMT calculation may apply.
- Net Investment Income Tax: Some higher-income taxpayers may owe the separate 3.8% tax.
- Self-employment tax: Freelancers may owe Social Security and Medicare taxes in addition to income tax.
- Payroll taxes: Social Security and Medicare withholding are not part of the ordinary income-tax bracket calculation.
- State and local taxes: These require separate calculations.
To estimate a refund or balance due, you must also include withholding and applicable payments. In general, a refund can result from over-withholding without changing your effective tax rate. Form 1040 is the annual individual income-tax return, while Form W-4 provides withholding information to an employer; see the IRS Form 1040 page and forms and instructions index.
Protect the workbook from common errors
- Using salary as taxable income: Label B2 clearly or calculate taxable income separately.
- Applying one rate to all income:
=Income*MarginalRateoverstates tax because earlier slices use lower rates. - Mixing tax years: Put a visible “Tax year: 2026” label on the sheet and update every threshold and deduction together.
- Using the wrong status: The same taxable income can produce different tax under different filing statuses.
- Omitting base tax:
=(Income-LowerThreshold)*Ratecalculates only the current slice. Add the prior tax withBaseTax+(Income-LowerThreshold)*Rate. - Using unsorted lookup thresholds: Approximate lookups can return the wrong bracket.
- Accepting invalid inputs: Use
MAX(0,B2)for a nonnegative income calculation. To flag blanks or text rather than treating them as zero, wrap the formula withIFERROR, such as=IFERROR(your_formula,"Check taxable income"). - Rounding each bracket: Round the final result unless the applicable IRS instructions require otherwise.
Test the calculator at bracket boundaries
Before relying on the workbook, test at least these taxable-income values:
- $0
- $12,400
- $12,401
- $50,400
- $50,401
- $100,000
- $640,600
- An amount above $640,600
At each boundary, confirm that the tax increases smoothly and that the marginal rate changes only when income moves above the threshold. For verification, compare the result with the applicable IRS tax computation worksheet in Publication 505, which uses the filing status, taxable income, applicable rate, and subtraction amount.
When Excel is not enough
Use tax-preparation software, official IRS forms and instructions, or a qualified tax professional when your return includes substantial investment income, self-employment, multiple states, complex credits, AMT, business activity, or other schedules that the workbook does not model. Update the tables whenever the IRS publishes new tax-year thresholds.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
