Documentation/Calc Functions/ROUNDUP

From The Document Foundation Wiki
Jump to: navigation, search

Other languages:

Function name:

ROUNDUP

Category:

Mathematical

Summary:

Rounds a number up, away from zero, to a certain precision.

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 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 up to an integer. If Count is negative, the function rounds up to the next 10, 100, 1000, etc.

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