ISO.CEILING(number [,significance])

Returns the number rounded up to the nearest integer or significant figure (renamed).

numberThe value to be rounded.
significanceThe multiple you want "number" rounded to.

Remarks

* CEILING.MATH was added in Excel 2013 to replace this function.
* This function was available in the 2010 beta but was renamed to CEILING.PRECISE in the final 2010 release.
* This function does not appear in the function autocomplete in Excel 2013.
* This function is only available for backwards compatibility and should never be used.
* This function does not appear in the "Insert Function" dialog box in Excel 2013.
* This function does not appear in the function autocomplete in Excel 2013..
* The number is always rounded up.
* If "significance" is left blank, then 1 is used.
* If "significance < 0, then 0 is returned.
* If "significance = 0, then 0 is returned.
* For the Microsoft documentation refer to support.office.com

 A
1=ISO.CEILING(4.3) = 5
2=ISO.CEILING(-3,2) = -2


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top