VAT / Sales Tax Calculator
Add tax to a net amount or extract tax from a tax-inclusive amount, with matching Excel formulas.
Net Amount
—
—
Tax Amount
—
—
Gross / Total Amount
—
—
Tax as % of Gross
—
—
Formula guide:
Add Tax: Tax = Net × Rate. Gross = Net + Tax.
Remove Tax: Net = Gross ÷ (1 + Rate).