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
Round unit costs to cents with ROUND
The situation
Harbor Supply's landed unit costs come out of the freight allocation with four decimal places. The price list shows two, but the column is only formatted that way — the totals underneath still use the long values, so the printed prices never quite add up to the printed total. Finance wants the stored value itself rounded to cents.
A1
fx
| Row number | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Item | Landed cost | Rounded | ||
| 2 | Pallet jack | 12.3456 | |||
| 3 | Stretch wrap | 8.9950 | |||
| 4 | Strap kit | 23.4049 | |||
| 5 | Dock bumper | 41.0050 | |||
| 6 |
Functions in this exercise
- ROUND — Rounds a number to a set number of decimal places, changing the stored value. Syntax and example
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 - BeginnerMath Functions
Apply a percentage discount to a list price
Work out what a customer pays after their contracted discount.
5 min15 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