The ROUNDUP function rounds up a number to a specified number of digits or decimals. In this guide, we’re going to show you how to use the ROUNDUP function and also throw in some tips and error handling methods.
Supported versions
- All versions
Syntax
ROUNDUP(number,[num_digits])
Arguments
number |
The number to be rounded. |
[num_digits] |
The number of digits. |
Examples
Firstly a reminder: Named ranges are added to ease of reading formulas.
Example 1
=ROUNDUP(314.159265358979,2)
Example 2
=ROUNDUP(314.159265358979,0)
Example 3
=ROUNDUP(314.159265358979,-2)