Calculation Issues

How to Calculate the Original Amount from a Tax-Inclusive Excel Total

Nimra Malik Oct 23, 2026 869 views

Question details

The user needs to calculate the original, pre-tax principal amount from a total that already includes a percentage-based tax.

How to Calculate the Original Amount from a Tax-Inclusive Excel Total

Product: Excel
Device & OS: not provided
Scenario: Reversing a tax calculation to find the original amount when given the final tax-inclusive total and the applied tax rate (e.g., extracting the original price before a 15% tax was added to reach $1,610).
Observed behavior: Subtracting the tax percentage directly from the final total yields an incorrect result. For example, $1,610 minus 15% does not return the correct original amount of $1,400.

Before you start

Ensure you have the final tax-inclusive total and the exact tax percentage rate applied. Remember that percentages are based on the original base amount, meaning you cannot accurately reverse the math by subtracting the tax rate directly from the final total.

Solution 1Recommended

Use the Division Formula to Find the Original Amount

The correct mathematical approach to find a pre-tax amount is to divide the total by 1 plus the tax percentage rate.

Because a tax percentage is originally applied to the principal amount, you cannot reverse it by subtracting that same percentage from the final total. If the original amount represents 100% and the tax is 15%, the final total represents 115% (or 1.15) of the original amount. Therefore, division must be used to reverse the calculation.

Enter your known data

Type your tax-inclusive total in a cell, such as A2 (e.g., 1610), and your tax rate in another cell, such as B2 (e.g., 15%).

Apply the division formula

Select an empty cell where you want the original amount to appear (e.g., C2). Type the formula `=A2/(1+B2)` and press Enter.

Calculate the exact tax amount (Optional)

Once Excel calculates the original pre-tax amount (e.g., 1400), you can find the exact tax amount paid by subtracting the original amount from your total. In cell D2, type `=A2-C2`.

Use the Division Formula to Find the Original Amount

Formatting Tip: Format your result cells as Currency or Accounting to ensure your financial calculations are easy to read and automatically rounded to two decimal places.

Manage Finances with WPS Spreadsheet

Easily Calculate Taxes and Finances in WPS Office

WPS Spreadsheet provides a powerful, free platform to handle all your financial formulas, including complex tax calculations, reverse percentage operations, and accounting ledgers.

1. Open WPS Spreadsheet: Launch WPS Office on your device and create a new blank spreadsheet.
2. Input your financial values: Enter your tax-inclusive total amounts and tax rates into the spreadsheet grid.
3. Enter the formula: Use the exact same `=Total/(1+Tax%)` formula as you would in Microsoft Excel to extract your pre-tax amounts.
4. Format and save: Apply currency formatting from the Home tab and save your document in .xlsx format for complete cross-platform compatibility.

Fully compatible with Microsoft Excel formulas and .xlsx filesBuilt-in financial, logical, and mathematical functionsFree, lightweight, and easy to use on Windows, Mac, and mobileSeamlessly handle tax-inclusive and exclusive calculations

microsoft office alternative - wps office

Frequently Asked Questions

Why can't I just subtract 15% from the total to get the original amount?

Percentages are relative to the base value they are applied to. A 15% tax is calculated on the smaller original amount, not the larger final total. Subtracting 15% from the larger total subtracts a proportionally bigger number than the actual tax that was added, leading to an incorrect, smaller result.

How do I find the actual tax amount after calculating the original price?

Once you calculate the original amount using the `=Total/(1+Tax Rate)` formula, simply subtract the calculated original amount from your tax-inclusive total (e.g., `=Total - Original`) to find the exact tax amount paid.

Does this formula work for finding original prices before a discount?

For discounts, the logic is similar but reversed. If a total is the result of a 15% discount, the final price is 85% of the original. To find the pre-discount price, you would divide the discounted total by 1 minus the discount rate using the formula `=Total/(1-Discount Rate)`.

Excel & Data Problems