OpenOffice.org Calc 3. Mathematical Functions
ROUNDUP(number; count) Function
Rounds the argument “number” with the
precision determined by the argument “count”. The approximation always makes
approaching zero. Therefore, the number to be rounded is positive, returns a
number greater than or equal to the value. Therefore, if the number to round is
negative, returns a number less than or equal to that value. The argument
“number” can take any numerical value. Contains the value to round. The argument
“count” is optional, contains a integer numerical value. This argument indicates
the number of decimal digits that shows the result. If “count” is zero or
omitted, makes the round to nearest integer. If the argument “count” is a
negative number, rounding makes it to the nearest 10, 100, 100, and so on. If
“count” is a negative number, the function returns an integer. Look at the
examples to better understand the function.
=ROUNDUP(18,443434;2) Returns 18,45.
=ROUNDUP(-223,4566;2) Returns -223,46.
=ROUNDUP(345,4566) Returns 346. Is omitted “count”. Returns the integer greater
than the argument “number”.
=ROUNDUP(-4344;0) Returns -4344. Omit the argument “count”, returns the integer
greater than the argument “number”.