# Documentation/Calc Functions/CEILING.PRECISE

Jump to navigation
Jump to search

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

## Function name:

CEILING.PRECISE

## Category:

Mathematical

## Summary:

Rounds a number up to the nearest multiple of a significance value.

For a positive number the function rounds up (away from zero). For a negative number, the function rounds up (towards zero). The sign of the significance value is ignored.

## Syntax:

CEILING.PRECISE(**Number** [; **Significance**])

## Returns:

Returns an integer value.

## Arguments:

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

**Significance** (optional) is the real number value, or a reference to a cell containing the value, to whose multiple Number is to be rounded. It's sign is ignored.

## Additional details:

## Examples:

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

=CEILING.PRECISE(11.5) | rounds up 11.5 to nearest multiple of +1(default) | 12 |

=CEILING.PRECISE(-11.5) | rounds up -11.5 to nearest multiple of -1(default) | -11 |

=CEILING.PRECISE(-11;-2) | rounds up -11 to nearest multiple of -2 | -10 |

=CEILING.PRECISE(-11;2) | rounds up -11 to nearest multiple of -2 rounding up towards 0 ignoring the sign of significance being passed | -10 |

## Related LibreOffice functions:

## ODF standard:

None

## Equivalent Excel functions:

CEILING.PRECISE