# Documentation/Calc Functions/ROUNDUP

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

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

## ODF standard:

## Equivalent Excel functions:

ROUNDUP