# Documentation/Calc Functions/ROUNDUP

Other languages:

ROUNDUP

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.

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

ROUND

ROUNDDOWN

TRUNC

INT

## ODF standard:

Section 6.17.7, part2

ROUNDUP