The price before tax and the tax inside a tax-inclusive price.
Your figures
Keep units consistent: kg with kg, minutes with minutes. Results update as you type.
Price before tax
—
Tax included
—
Formula
Price including tax ÷ (1 + tax rate)
=B2/(1+C2/100)Excel: B2 price including tax; C2 tax rate
Taking the tax rate off the inclusive price (11,800 − 18%) gives the wrong answer; divide instead.
Save this calculation
Enter your figures (or try the worked example) to save them.
General calculation. Confirm your site's own definitions, validated limits and specifications before using a result for process control or product release.