BeginnerMath Functions
Total a month of sales with SUM
Add up a column of daily sales figures to get the monthly total.
SUM
3 min10 points
Apply a percentage discount to a list price
The situation
Harbor Supply gives each distributor a contracted discount off list. The order desk needs the actual price to quote, and right now they are working it out on a calculator for every line.
A1
fx
| Row number | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Customer | List price | Discount | Net price | |
| 2 | Dockside Hardware | $2,400 | 15% | ||
| 3 | Fenwick Building | $1,850 | 10% | ||
| 4 | Alder & Vance | $3,200 | 20% | ||
| 5 | Riverbend Trade | $990 | 5% | ||
| 6 | Kemper Outfitters | $4,750 | 13% | ||
| 7 |
Who this is for
Recommended next
Related exercises
- BeginnerFormulas
Calculate line totals with multiplication
Multiply quantity by unit price to get a line total.
3 min10 points - BeginnerFormulas
Calculate achievement against target
Divide actual sales by target to get an achievement percentage.
3 min10 points - BeginnerMath Functions
Total a month of sales with SUM
Add up a column of daily sales figures to get the monthly total.
SUM
3 min10 points