Syntax
=ROUNDUP(number, num_digits)Arguments
| Argument | Required | Description |
|---|---|---|
number | Required | The number to round |
num_digits | Required | Digits after the decimal point (negative rounds to the left of it) |
How to use ROUNDUP
ROUNDUP takes 2 required arguments. Type =ROUNDUP( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=ROUNDUP(3.2, 0)Result =ROUNDUP(-3.14159, 1)Result =ROUNDUP(31415.92654, -2)Result Related math functions
- RANDBETWEENReturns a random whole number between two numbers (both included).
- ROMANConverts a number to Roman numerals as text; form 0 is classic and 1 to 4 are ever more concise.
- ROUNDRounds a number to a given number of digits, halves away from zero.
- ROUNDDOWNRounds a number toward zero to a given number of digits.
- SECReturns the secant of an angle given in radians.
- SECHReturns the hyperbolic secant of a number.
- SERIESSUMReturns the sum of a power series: a1*x^n + a2*x^(n+m) + ...
- SIGNReturns 1 for a positive number, -1 for a negative number and 0 for zero.
- SINReturns the sine of an angle given in radians.