ISO.CEILING function
Summary
Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance
Syntax
ISO.CEILING(number, [significance])
The ISO.CEILING function syntax has the following arguments:
• Number Required. The value to be rounded.
• Significance Optional. The optional multiple to which number is to be rounded. If significance is omitted, its default value is 1. Note: The absolute value of the multiple is used, so that the ISO.CEILING function returns the mathematical ceiling irrespective of the signs of number and significance.
• Number Required. The value to be rounded.
• Significance Optional. The optional multiple to which number is to be rounded. If significance is omitted, its default value is 1. Note: The absolute value of the multiple is used, so that the ISO.CEILING function returns the mathematical ceiling irrespective of the signs of number and significance.
Example
=ISO.CEILING(4.3)
=ISO.CEILING(-4.3)
=ISO.CEILING(4.3, 2)
=ISO.CEILING(4.3,-2)
=ISO.CEILING(-4.3,2)
=ISO.CEILING(-4.3,-2)
=ISO.CEILING(-4.3)
=ISO.CEILING(4.3, 2)
=ISO.CEILING(4.3,-2)
=ISO.CEILING(-4.3,2)
=ISO.CEILING(-4.3,-2)