<< Click to Display Table of Contents >> ROUNDUP (round up to n digits) |
Syntax:
ROUNDUP(Number, n)
Description:
Rounds Number up (away from zero) to n decimal places.
n is the number of decimal places.
If n is omitted, Number is rounded to the nearest integer.
If n is a negative value, Number is rounded up to the left of the decimal point. For example, if n is -2, Number is rounded up to the nearest multiple of hundred (see second last example).
Note:
Negative numbers are not rounded up, but down (see last example). This is not mathematically correct, but for compatibility reasons it is implemented exactly as in Microsoft Excel.
Example:
ROUNDUP(1.234, 2) returns 1.24
ROUNDUP(1.235, 2) returns 1.24
ROUNDUP(444.222, 0) returns 445
ROUNDUP(444.222, -2) returns 500
ROUNDUP(-7.3, 0) returns -8
See also:
ROUNDDOWN, ROUND, MROUND, TRUNC, FIXED, INT, EVEN, ODD, CEILING, FLOOR