# Documentation/Calc Functions/CEILING.PRECISE

Jump to navigation Jump to search
Other languages:
English • ‎dansk

CEILING.PRECISE

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: This function calculates identical results to the ISO.CEILING function.

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

None

CEILING.PRECISE