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”.

Back to the list of mathematical functions