Sales Tax Calculator
Add sales tax to a net price, or back the tax out of a total, with the Excel and Google Sheets formulas.
Enter the rate as a percent (8.25 for 8.25%). Numbers stay in your browser. The default is a net price of 80 at 8.25%, which is a total of 86.6. This is arithmetic, not tax advice for a particular place.
Quick answer: with the net price in B2 and the rate in C2 as 8.25% or 0.0825:
=B2*C2
=B2*(1+C2)The first is the tax; the second is the total. To start from a tax-inclusive total in B2, the net is =B2/(1+C2).
8.25% on 80, and the other way around
In Google Sheets on 12 November 2026, =80*0.0825 returned 6.6000000000000005 — the familiar binary stand-in for 6.6 — and =80*(1+0.0825) returned 86.6. Working backwards, =86.6/1.0825 recovered the net of 80. Subtracting that net from 86.6 returned 6.599999999999994 as the tax portion, again a floating-point rendering of 6.6. If you need a currency total, round to two decimals in the sheet with =ROUND(B2*(1+C2),2).
A cleaner check at 10%: =100*0.10 is 10, and =100*1.10 returned 110.00000000000001. Type 8.25% 或 0.0825 in the rate cell. A plain 8.25 is treated as 825% and will blow the total up.
One rate, not a stacked invoice
This page uses a single rate on a single amount. If a city rate sits on top of a state rate, you need the combined rate your jurisdiction actually charges (sometimes they stack, sometimes the second is applied only to the net). Excise taxes, VAT with a different inclusive convention, and exemptions are outside the formula. A discount usually comes off the net before tax, not after.
Questions that come up
How do I add sales tax in Excel or Google Sheets?
With the net price in B2 and the rate as 8.25% or 0.0825 in C2, the tax is =B2*C2 and the total is =B2*(1+C2). On 80 at 8.25%, the total is 86.6. Type 8.25% or 0.0825, not the whole number 8.25, unless you also divide by 100.
How do I back sales tax out of a total?
If B2 is the tax-inclusive total and C2 is the rate, the net (pre-tax) amount is =B2/(1+C2) and the tax portion is =B2-B2/(1+C2). 86.6 at 8.25% returns a net of 80.
Is sales tax the same as a discount or a margin?
No. Sales tax is added on top of (or embedded in) a price. A discount comes off a list price, and a margin is profit against the selling price. Use the discount or markup vs margin calculators for those.