Challenge 5

Order of operations

1. Open our example file. Make sure you're signed in to Google, then click File > Make a copy.
2. Select the Challenge sheet. Let's say we want to compare two discounts. The first discount takes 20% off the total, and the second discount takes $30 off the total.
3. In cell D6, create a formula that calculates the total using the 20% off discount.
4. Hint: Because we're taking 20% off, 80% of the total will remain. To calculate this, multiply 0.80 by the sum of the line totals.
5. In cell D7, create a formula that subtracts 30 from the total.
6. When you're finished, your spreadsheet should look like this: