Open our practice workbook.
Click the Challenge worksheet tab in the bottom-left of the workbook.
In cell D7, create a formula that calculates the tax for the invoice. Use a sales tax rate of 7.5%.
In cell D8, create a formula that finds the total for the order. In other words, this formula should add cells D3:D7.
In cell D9 create a formula that calculates the total after a 10% discount. If you need help understanding how to take a percentage off of a total, review our lesson on Discounts, Markdowns, and Sales.
When you’re finished, your spreadsheet should look like this:
Complex Formulas Challenge
In cell D7, create a formula that calculates the tax for the invoice and use a sales tax rate of 7.5%.
