• Around The HomeToggle Menu

    • Entertainment
    • Productivity
    • Smart Home
  • FamilyToggle Menu

    • Parenting
    • Toys
    • Pets
    • Travel
  • Product ReviewsToggle Menu

    • Phones
    • Tablets
    • Laptops
    • Desktops
    • Wearables
    • Audio
    • Cameras
    • Headphones
    • Printers
    • Smart Home
    • TVs
    • Gaming and Video
  • One Cool ThingToggle Menu

    • Frugal Tech
    • Kickstarters
    • Videos
Techwalla
  1. Home
  2. Around The Home
  3. Productivity
  4. How to Calculate Sales Tax in Excel

How to Calculate Sales Tax in Excel

March 31, 2015
By: Shea Laverty
  • Share
  • Share on Facebook

The calculation tools of Excel spreadsheets make them well-suited to calculating financial transactions and reports. With an Excel spreadsheet, you can even work out sales tax on a transaction, as well as the total cost of the transaction after tax. To use these features, you'll need to enter the correct formulas in the appropriate spreadsheet cells.

Video of the Day

Step

Launch Excel and create a new document.

Step

Click Cell A1 and enter a name to describe the purchase price before tax, like "Sales Price."

Step

Click Cell B1 and enter a name to describe the tax rate in decimal form, like "Sales Tax Rate."

Step

Click Cell C1 and enter a name reflecting the actual tax cost, like "Sales Tax."

Step

Click Cell D1 and enter a name reflecting the total cost, like "Total."

Step

Click Cell A2 and enter the purchase price before tax. For example, 100.

Step

Click Cell B2 and enter the tax rate as a decimal. For example, for 10-percent sales tax, enter 0.10.

Step

Click Cell C2 and enter the following formula:

\=A2*B2

Step

Click Cell D2 and enter the following formula:

\=A2+C2

Show Comments

Related Articles

How to Tune a Ported Subwoofer Box

How to Tune a Ported Subwoofer Box

Around The Home
Entertainment
By: Contributing Writer
How to Calculate Gross Profit Margin Using Excel

How to Calculate Gross Profit Margin Using Excel

Around The Home
Productivity
By: David Weedmark
How to Calculate IRR in Excel

How to Calculate IRR in Excel

Around The Home
Productivity
By: Hunter Taylor
How to Calculate P Value in Excel

How to Calculate P Value in Excel

Around The Home
Productivity
By: Nina Nixon
How to Calculate the Number of Hours Between 2 Times in Excel

How to Calculate the Number of Hours Between 2 Times in Excel

Around The Home
Productivity
By: Danielle Cort
How Do I Use Subtotals and Totals in an Excel Spreadsheet?

How Do I Use Subtotals and Totals in an Excel Spreadsheet?

Around The Home
Productivity
By: David Weedmark
  • HOW WE SCORE
  • ABOUT US
  • CONTACT US
  • TERMS
  • PRIVACY POLICY
  • COPYRIGHT POLICY
  • Advertise

An error occurred. Try again later.

Thanks for signing up!
© 2018 Leaf Group Ltd. Leaf Group Media

Get great tech advice delivered to your inbox.

Keep your family productive, connected, entertained, and safe.

Please enter a valid email.