Documentation/Calc Functions/ROUNDUP

From The Document Foundation Wiki
Jump to: navigation, search
This page contains changes which are not marked for translation.

Other languages:
dansk • ‎English

Function name:

ROUNDUP

Category:

Mathematical

Summary:

Rounds a number up, away from zero, to a certain precision. So, it rounds positive numbers up and negative numbers down.

Syntax:

ROUNDUP(Number [; Count])

Returns:

Returns Number rounded up (away from zero) to Count decimal places.

Arguments:

Number is a real number or a reference to the cell containing that number which is to be rounded up to a certain number of decimal places.

Count is an integer or a reference to the cell containing that integer which is the number of decimal places to which Number is to be rounded up.

  • If Count is omitted or zero, the function rounds to the nearest integer. If Count is negative, the function rounds to the nearest 10, 100, 1000, etc.
  • If Count is a non-integer value then the function uses the floor of the input value, i.e. it is truncated to an integer. For eg. 2.5 is truncated to 2 and -2.5 is truncated to -2.

Additional details:

This function rounds away from zero. See ROUNDDOWN and ROUND for alternatives.

Examples:

Formula Description Returns
=ROUNDUP(1.1111;2) rounds up 1.1111 to 2 decimal places 1.12
=ROUNDUP(1.2345;1) rounds up 1.2345 to 1 decimal place 1.3
=ROUNDUP(45.67;0) give integer part of 45.67 46
=ROUNDUP(-45.67) rounds up -45.67 to integer, but negative number hence rounds it down away from 0 -46
=ROUNDUP(987.65;-2) rounds up 987.65 to 2 places before decimal point 1000

Related LibreOffice functions:

ROUND

ROUNDDOWN

TRUNC

INT

ODF standard:

Section 6.17.7, part2

Equivalent Excel functions:

ROUNDUP