Rounds up a given number to a specified number of digits.
Sample Usage
ROUNDUP(15.55,0)
ROUNDUP(15.55, 1)
ROUNDUP(C5)
Syntax
ROUNDUP(number, [count])
- number - The number to be rounded.
- count - [OPTIONAL] The number of places to which the number is to be rounded.
Examples
ROUNDUP(15.55,0) returns the number 16.
ROUNDUP(15.55, 1) returns the number 15.6.
Notes
- ROUNDUP behaves like ROUND, except that it always rounds a number up.
- If count is greater than 0 (zero), then number is rounded up to the specified number of decimal places.
- If count is 0, the number is rounded to the nearest integer.
- If count is less than 0, the number is rounded to the left of the decimal point.