Math
ROUNDUP
Definition
ROUNDUP returns a number rounded away from zero to a given number of digits.
Syntax
=ROUNDUP(number, num_digits)
Arguments
| Argument | Meaning |
|---|---|
number |
The value to round, or the cell holding it. |
num_digits |
How many digits to keep. 0 rounds to a whole number; 2 keeps two digits after the decimal point. |
Worked example
A lab records masses that must always round up to two decimal places. Masses are in B2:B4.
| A: Sample | B: Mass |
|---|---|
| A | 3.141 |
| B | 2.001 |
| C | 5.990 |
Formula: =ROUNDUP(B2,2)
Result: 3.15. The third decimal of 3.141 is 1, but ROUNDUP still lifts the second decimal from 4 to 5.
Practice
Cell A2 holds 12.1. In B2, write a formula that rounds it up to 0 decimal places.
- In B2, write a ROUNDUP formula that rounds A2 up to 0 decimal places.
- B2 should show A2 rounded up to 0 decimal places.
Step 1 of 2
Enter =ROUNDUP(A2,0) in B2.
A2 is 12.1, so rounding up to 0 decimal places gives 13.
Formulas here use English function names, such as SUM, and a period as the decimal separator, in every language.
Loading the sheet…
B2 uses ROUNDUP.
B2 now shows 13.
Related functions
ROUND follows ordinary rounding, so 3.141 to two digits becomes 3.14. AVERAGE is a common source of the number you then lift with ROUNDUP.
Common mistake
Using ROUND when a value must never go down: ROUND(3.141,2) is 3.14, while ROUNDUP(3.141,2) is 3.15.