# 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 away from zero to the next multiple of a specified power of 10.

## Syntax:

ROUNDUP(**Number**[; **Count**])

## Returns:

Returns a real value which is the specified number rounded (away from zero) to the required precision.

## Arguments:

**Number** is a real number, or a reference to a cell containing that number, that is to be rounded.

**Count** is an integer, or a reference to a cell containing that integer, that is used to specify the precision of the rounding. If **Count** is omitted, a default value of 0 is assumed. The value of **Count** is utilized as follows:

- If
**Count**is a positive integer, then rounding is to the right of the decimal separator. For example, if**Count**is equal to 1 then numbers are rounded (away from 0) to the next multiple of [math]\displaystyle{ \frac{1}{10}\text{th} }[/math]; if**Count**is equal to 2 then numbers are rounded (away from zero) to the next multiple of [math]\displaystyle{ \frac{1}{100}\text{th} }[/math]; and so on. - If
**Count**is equal to zero, then rounding is to the next integer away from 0. - If
**Count**is a negative integer, then rounding is to the left of the decimal separator. For example, if**Count**is equal to -1 then numbers are rounded (away from 0) to the next multiple of 10; if**Count**is equal to -2 then numbers are rounded (away from 0) to the next multiple of 100; and so on. The value returned by ROUNDUP will always be an integer when**Count**is negative.

The following conditions (including errors) may be encountered:

- If either
**Number**or**Count**is non-numeric, then ROUNDUP reports a #VALUE! error. - If
**Count**is a non-integer value, then it is rounded to the next integer in the direction of 0.

## Additional details:

- If you obtain unexpected results from ROUNDUP, check the following:

- Make sure that the number of displayed decimal places is not affected by the setting of the
**Limit decimals for general number format**option in the*General Calculations*area of the ▸ ▸ ▸ dialog ( ▸ ▸ ▸ on macOS). - Access the tab on the Format Cells dialog ( ▸ or equivalent interaction) to make sure that relevant cells do not have formatting applied that affects the number of displayed decimal places.

- Make sure that the number of displayed decimal places is not affected by the setting of the

## Examples:

Formula | Description | Returns |
---|---|---|

=ROUNDUP(2.348; 2) | Here the function rounds 2.348 away from 0, to 2 decimal places. | 2.35 |

=ROUNDUP(D1; D2) where cells D1 and D2 contain the numbers -32.4834 and 3.2 respectively. | The value of the Count argument is truncated to 3. Here the function rounds -32.4834 away from 0, to 3 decimal places. |
−32.484 |

=ROUNDUP(2.648; 0) | Here the function rounds 2.648 away from 0, to the next integer. The alternative formula `=ROUNDUP(2.648)` returns the same value. |
3 |

=ROUNDUP(−45.67) | Here the function rounds -45.67 away from 0, to the next integer. | −46 |

=ROUNDUP(887.65; −2) | Here the function rounds 887.65 away from 0, to the next hundred. | 900 |

## Related LibreOffice functions:

## ODF standard:

## Related (or similar) Excel functions:

ROUNDUP