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.

Remarks

* This function does not appear in the Function Wizard or the Cell AutoComplete.
* This function is only available for backwards compatibility and should never be used.
* CEILING.MATH was added in Excel 2013 to replace this function.
* This function was added in Excel 2010 to replace the CEILING function.
* The number is always rounded up.
* Alternative formula is = INT(-number/ ABS(significance) )*ABS(significance)
* For the Microsoft documentation refer to support.office.com

 A
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.PRECISE(-1.9,-1) = -1
7=CEILING.PRECISE(2.5,2) = 4
8=CEILING.PRECISE(-2.5,-2) = -2
9=CEILING.PRECISE(8,1.5) = 9
10=CEILING.PRECISE(8.26,0.05) = 8.3
11=CEILING.PRECISE(0.234,0.01) = 0.24
12=CEILING.PRECISE(4.2,1) = 5
13=CEILING.PRECISE(4.2,-1) = 5
14=CEILING.PRECISE(4.2,2) = 6
15=CEILING.PRECISE(4.2,-2) = 6
16=CEILING.PRECISE(-4.2,1) = -4
17=CEILING.PRECISE(-4.2,-1) = -4
18=CEILING.PRECISE(-4.2,2) = -4
19=CEILING.PRECISE(-4.2,-2) = -4
20=CEILING.PRECISE(4,-2) = 4
21=CEILING.PRECISE(-2.5,2) = -2


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