Course outline / Mathematical functions
Lesson 13 of 75 · Intermediate · 6 exercises
Rounding and maths functions
Round numbers, find remainders and multiply lists.
What you'll practise
- Round to one decimal
- Always round up
- Always round down
- Find a remainder with MOD
- Remove the sign with ABS
- Multiply and add with SUMPRODUCT
Round to one decimal
Calculations often produce long decimals. ROUND tidies a number to the number of decimal places you choose.
=ROUND(number, decimal places)
In cell E2, round the value in A2 to 1 decimal place.
Always round up
ROUNDUP always rounds away from zero, which is useful when you can't have part of something, like boxes or buses. Using 0 decimal places gives a whole number.
=ROUNDUP(number, decimal places)
In cell E2, round A2 up to a whole number.
Always round down
ROUNDDOWN does the opposite and always rounds towards zero, dropping the extra decimals.
In cell E2, round A2 down to a whole number (0 decimal places).
Find a remainder with MOD
MOD gives the remainder after division. For example, =MOD(7,3) is 1, because 3 goes into 7 twice with 1 left over. It's often used to spot every second or third row.
=MOD(number, divisor)
In cell E2, find the remainder when A3 is divided by 4.
Remove the sign with ABS
ABS returns a number's size without its sign, so -15 becomes 15. It's useful for measuring how far apart two figures are, whichever is bigger.
In cell E2, use ABS to get the size of the value in A4.
Multiply and add with SUMPRODUCT
SUMPRODUCT multiplies two ranges row by row, then adds up the results, all in one step. That's exactly how you total an order from quantities and prices.
=SUMPRODUCT(range 1, range 2)
In cell E2, find the total order value: the quantities in B2:B4 times the prices in C2:C4.
Try it in a real spreadsheet
Every step checks your answer instantly and tells you exactly what to fix.