How To Calculate Sales Tax In Excel

How to calculate sales revenue enhancement in Excel?

As we know, we e'er pay the sales tax when shopping except purchasing duty-free appurtenances. But do yous know how many sales taxation yous have paid? There are two conditions to summate the sales tax in Excel.

Calculate sales tax if you get price exclusive of revenue enhancement
Calculate sales revenue enhancement if you become tax-inclusive price

Calculate sales tax if you lot get toll exclusive of revenue enhancement

Sometimes, you lot may get the price exclusive of revenue enhancement. In this condition, y'all can easily calculate the sales tax by multiplying the cost and revenue enhancement rate.

Select the jail cell yous volition place the calculated issue, enter the formula =B1*B2 (B1 is the price exclusive of taxation, and B2 is the tax rate), and press the Enter primal.

And now y'all can get the sales tax easily. See screenshot:

Calculate sales revenue enhancement if you get revenue enhancement-inclusive price

In some regions, the tax is included in the cost. In the status, you lot tin figure out the sales tax as follows:

Select the prison cell you will identify the sales tax at, enter the formula =E4-E4/(1+E2) (E4 is the tax-inclusive price, and E2 is the tax rate) into it, and press the Enter key.

And now you lot can go the sales tax easily. See screenshot:

The All-time Office Productivity Tools

Kutools for Excel Solves Most of Your Issues, and Increases Your Productivity past 80%

Reuse: Quickly insert circuitous formulas, charts and anything that you take used before; Encrypt Cells with countersign; Create Mailing Listing and send emails...
Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
Merge Cells/Rows/Columns without losing Information; Split Cells Content; Combine Indistinguishable Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Discover in Many Workbooks; Random Select...
Exact Copy Multiple Cells without irresolute formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
Excerpt Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
Super Filter (salve and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by assuming, italic...
Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Information into Multiple Sheets; Batch Convert xls, xlsx and PDF...
More than 300 powerful features. Supports Part/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or system. Total features xxx-day complimentary trial. lx-day money back guarantee.

kte tab 201905

Part Tab Brings Tabbed interface to Function, and Make Your Work Much Easier

Enable tabbed editing and reading in Word, Excel, PowerPoint , Publisher, Admission, Visio and Projection.
Open and create multiple documents in new tabs of the aforementioned window, rather than in new windows.
Increases your productivity by fifty%, and reduces hundreds of mouse clicks for you lot every day!

officetab bottom