CEILING.PRECISE(number [,significance])

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

numberThe number to be rounded up.
significance(Optional) The multiple you want the number rounded to.

* This function was added in Excel 2010 to replace the CEILING function.
* This function was then replaced in Excel 2013 with the CEILING.MATH function.
* This function is only available for backwards compatibility and should never be used.
* This function does not appear in the Function Wizard or the Cell AutoComplete.
* There was also a FLOOR.PRECISE that rounded the number down.
* If "significance" is left blank, then 1 is used.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

1=CEILING.PRECISE(1.1,1) = 2
2=CEILING.PRECISE(1.5,1) = 2
3=CEILING.PRECISE(1.9,1) = 2
4=CEILING.PRECISE(-1.1,-1) = -1
5=CEILING.PRECISE(-1.5,-1) = -1
6=CEILING.MATH(-1.9,-1) = -1
7=CEILING.PRECISE(-1.9,-1) = -1
8=CEILING(-1.9,-1) = -2

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