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.
Launch Excel and create a new document.
Video of the Day
Click Cell A1 and enter a name to describe the purchase price before tax, like "Sales Price."
Click Cell B1 and enter a name to describe the tax rate in decimal form, like "Sales Tax Rate."
Click Cell C1 and enter a name reflecting the actual tax cost, like "Sales Tax."
Click Cell D1 and enter a name reflecting the total cost, like "Total."
Click Cell A2 and enter the purchase price before tax. For example, 100.
Click Cell B2 and enter the tax rate as a decimal. For example, for 10-percent sales tax, enter 0.10.
Click Cell C2 and enter the following formula:
Click Cell D2 and enter the following formula: