Formulo
Formulo

Practice

  • Exercises0/121

Learn

  • Functions19

Your account

  • My account
  • Pricing
Topic 1 · First formulas
Exercise 2 of 12
  1. 1. Add up the month's expenses
  2. 2. Work out the sales tax on each product
  3. 3. Work out each month's profit
  4. 4. Multiply quantity by priceLocked
  5. 5. Work out the average scoreLocked
  6. 6. Find the best sales dayLocked
  7. 7. Find the cheapest supplierLocked
  8. 8. Count who has handed in the assignmentLocked
  9. 9. Work out each store's share of the totalLocked
  10. 10. Apply a discount to the whole listLocked
  11. 11. Review: how much does the price vary between storesLocked
  12. 12. Review: the average without the highest scoreLocked
←→

Work out the sales tax on each product

You have a price list before tax. The tax rate sits in a single cell.

Task

In C2, calculate the tax using the rate in F1, then drag the formula down to C6.

⋯

Loading the sheet…