To calculate tax in Excel, multiply a taxable amount by a tax rate using a formula like =A2*B2, where A2 holds the dollar amount and B2 holds the rate as a decimal (0.07 for 7%). That single operation handles sales tax, FICA withholding, and flat-rate line items. Progressive federal income tax needs a bracket table paired with VLOOKUP, and self-employment tax has its own multiplier. Everything else is variations on those patterns.
Set Up the Worksheet First
Pull your source documents before opening Excel: Form W-2 for wages, Form 1099-NEC for freelance income, and any 1099-INT or 1099-DIV forms for investment earnings. The figures on these forms go to the IRS, so your spreadsheet should match them exactly.1Internal Revenue Service. Form 1099-NEC and Independent Contractors Keeping this documentation organized also satisfies the IRS requirement to retain records supporting every item of income, deduction, and credit on your return.2Internal Revenue Service. Topic No. 305, Recordkeeping
Create column headers across the first row: Description, Taxable Amount, Tax Rate, Tax Owed. Enter the gross income or transaction total under Taxable Amount and the rate as a decimal under Tax Rate. Keep each rate in its own cell rather than hardcoding it into a formula. When the rate changes, you edit one cell instead of hunting through dozens of formulas.
Separate different tax types onto distinct rows or tabs. Federal income tax, state income tax, and sales tax all use different rates and bases. Self-employment tax has its own logic entirely. Keeping them apart prevents the kind of cross-contamination that produces errors nobody catches until a notice arrives months later.
The Flat Rate Formula
If cell A2 contains a $500 purchase and cell B2 contains 0.06 for a 6% sales tax rate, type =A2*B2 in C2 and press Enter. The result is $30.00. Change the purchase price to $750 and the tax recalculates automatically.
The same approach handles FICA withholding on a paycheck. Social Security tax applies at 6.2% on wages up to $184,500 in 2026; Medicare tax applies at 1.45% on all wages with no cap.3Social Security Administration. Contribution and Benefit Base On a $5,000 paycheck, enter =5000*0.062 for Social Security and =5000*0.0145 for Medicare. Single filers above $200,000 owe an additional 0.9% Medicare surtax on the excess, so the formula for that piece is =(A2-200000)*0.009, applied only to income above the threshold.4Internal Revenue Service. Questions and Answers for the Additional Medicare Tax
Format the Tax Owed column as Currency with two decimals so dollar signs and rounding appear automatically. Select the column, right-click, choose Format Cells, and pick Currency.
Lock the Rate Cell When You Copy the Formula Down
When you apply the same rate to a long list of transactions, lock the reference to the rate cell so it does not shift as you drag. Put a dollar sign before both the column letter and the row number. If your rate lives in D1, the locked reference is $D$1, and a formula like =A2*$D$1 can be dragged from row 2 to row 500 with every row multiplying its own taxable amount by that single rate.
Without the dollar signs, Excel adjusts both references as you drag. Row 3’s formula would look for a rate in D2, pulling from an empty cell or the wrong data. This is the most common spreadsheet tax mistake, and it is completely silent. The formula returns a number that looks plausible and happens to be wrong. You can toggle any reference between relative and absolute by clicking it in the formula bar and pressing F4, which cycles through the lock options.
The technique matters for any repeated rate, including the 15% long-term capital gains rate applied to a list of investment sales.5Internal Revenue Service. Topic No. 409, Capital Gains and Losses Every sale has a different gain; they all multiply by one locked rate.
Progressive Income Tax With a Bracket Table
Federal income tax is not a single rate. The system taxes different slices of income at increasing rates across seven brackets. For 2026 single filers:6Internal Revenue Service. IRS Releases Tax Inflation Adjustments for Tax Year 2026
- 10% on income up to $12,400
- 12% from $12,401 to $50,400
- 22% from $50,401 to $105,700
- 24% from $105,701 to $201,775
- 32% from $201,776 to $256,225
- 35% from $256,226 to $640,600
- 37% on income over $640,600
Someone earning $60,000 does not pay 22% on the whole amount. They pay 10% on the first $12,400, 12% on the chunk up to $50,400, and 22% only on the remaining $9,600. A plain =income*rate formula would badly overstate the bill.
The cleanest way to handle this is a reference table paired with VLOOKUP. Build a table with four columns: the bracket floor (0, 12400, 50400, and so on), the marginal rate (0.10, 0.12, 0.22, and so on), the bracket width, and a cumulative tax column that totals the tax owed from all lower brackets. That cumulative column is the trick. It stores the fixed tax from every bracket below the current one, so you never have to recompute it.
The formula in your tax cell then reads:
=VLOOKUP(A2, bracket_table, 4, TRUE) + (A2 – VLOOKUP(A2, bracket_table, 1, TRUE)) * VLOOKUP(A2, bracket_table, 2, TRUE)
The first VLOOKUP retrieves the cumulative tax from lower brackets. The second pulls the floor of the current bracket and subtracts it from taxable income. The third grabs the marginal rate and multiplies it by that remaining slice. Setting the last argument to TRUE tells Excel to find the closest match without going over, which is exactly how bracket floors work.
Updating for future years is simple: change the numbers in the bracket table and every formula that references it recalculates. Married filing jointly uses different brackets ($24,800 at 10%, $100,800 at 12%, and so on), so keep a separate table for each filing status on its own tab.
Self-Employment Tax
Freelance and business income triggers self-employment tax covering both the employer and employee shares of Social Security and Medicare, a combined 15.3% (12.4% for Social Security, 2.9% for Medicare).7Internal Revenue Service. Self-Employment Tax (Social Security and Medicare Taxes) The IRS does not apply that rate to your full net earnings. You first multiply by 0.9235, which offsets the employer’s share of FICA the way an employee’s paycheck would. If net self-employment income is in A2, the taxable base formula is =A2*0.9235.
The 12.4% Social Security portion applies only up to the 2026 wage base of $184,500. If you also have W-2 wages, subtract those wages from the cap before applying the rate. A formula like =MIN(A2*0.9235, 184500-B2)*0.124, where B2 holds W-2 wages, handles the cap automatically. The Medicare portion has no ceiling: =A2*0.9235*0.029.
You can deduct half of your total self-employment tax when calculating adjusted gross income. The deduction reduces income tax but not the self-employment tax itself. Build a cell that divides your SE tax total by 2 and subtract it in your AGI calculation.
Feed Taxable Income, Not Gross, Into the Bracket Formula
The bracket calculator described above needs taxable income as its input. The path from gross to taxable runs through adjustments (which produce adjusted gross income) and then either the standard deduction or itemized deductions. For 2026, the standard deduction is $16,100 for single filers, $32,200 for married filing jointly, and $24,150 for head of household.8Internal Revenue Service. Revenue Procedure 2025-32 A formula like =B2-16100, where B2 is AGI, gives taxable income for a single filer.
Common above-the-line adjustments that reduce AGI include up to $2,500 in student loan interest and up to $300 in educator expenses ($600 if both spouses qualify).9Internal Revenue Service. Topic No. 458, Educator Expense Deduction List each adjustment on its own row, sum them, and subtract from gross income to reach AGI. If you itemize, use =MAX(itemized_total, standard_deduction) to have Excel pick whichever is larger.
Credits work differently from deductions. They reduce your tax bill dollar for dollar. The child tax credit for 2026 is worth up to $2,200 per qualifying child.10Internal Revenue Service. Child Tax Credit After the bracket formula calculates tax owed, subtract credits in a separate cell. Some credits like the Earned Income Tax Credit are refundable and can push tax below zero. Use =MAX(tax_owed – total_credits, 0) if you want to see the non-refundable floor, or allow negative numbers if you are tracking refundable credits separately.
Effective Tax Rate
Once total tax is calculated, one of the most useful numbers you can produce is the effective rate: =total_tax / total_income. If your bracket calculator returns $8,500 in tax on $62,000 of taxable income, the effective rate is about 13.7%. That figure is always lower than the marginal bracket rate, because only the top slice gets taxed at the highest rate.
Add a summary row at the bottom of the worksheet that pulls the two figures and divides them, formatted as a percentage. Tracking it year to year gives a clearer picture of actual tax burden than watching bracket rates, and it helps you gauge whether estimated payments are keeping pace with income growth.
Rounding for the Return
The IRS lets you round to whole dollars on your return. Drop anything under 50 cents; round 50 to 99 cents up. When adding figures for a line total, include cents during the addition and round only the final result.11Internal Revenue Service. 2025 Instructions for Form 1040 If you round, you must round every amount on the return, not selectively.
Excel’s ROUND function handles this cleanly. To round a value in C2 to the nearest dollar, use =ROUND(C2, 0). To keep two decimals for intermediate math, use =ROUND(C2, 2). With the second argument set to 0, Excel applies standard rounding, which matches the IRS rule exactly.12Microsoft Support. ROUND Function Build intermediate formulas at full precision and apply ROUND only in the cells that produce final line-item amounts.
A Tab for Quarterly Estimated Payments
If your worksheet shows a projected liability and no employer is withholding tax, you likely need to make quarterly estimated payments. The 2026 deadlines are April 15, June 15, and September 15 of 2026, plus January 15, 2027.13Internal Revenue Service. 2026 Form 1040-ES Missing them triggers an underpayment penalty unless total payments cover at least 90% of the current year’s tax or 100% of the prior year’s tax, whichever is smaller.14Internal Revenue Service. Topic No. 306, Penalty for Underpayment of Estimated Tax
Add a tab that divides projected annual tax by four and tracks each payment. A simple layout lists the deadline, the amount due (=annual_tax/4), the amount actually paid, and the running balance. The IRS charges interest on underpayments at rates that adjust quarterly: 7% for the first quarter of 2026 and 6% for the second.15Internal Revenue Service. Interest Rates Remain the Same for the First Quarter of 202616Internal Revenue Service. Internal Revenue Bulletin 2026-8 Updating the spreadsheet each quarter as real income comes in, rather than relying on a single January projection, keeps estimates close and penalty exposure low.