ECMA.CEILING

ECMA.CEILING(number, significance)

Returns the number rounded up to the nearest multiple of significance.

numberThe number to be rounded up.
significanceThe multiple you want the number rounded to.

REMARKS
* CEILING.MATH was added in Excel 2013 to replace this 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.

 A
1=ECMA.CEILING(1.1, 1) = 2
2=ECMA.CEILING(1.5, 1) = 2
3=ECMA.CEILING(1.9, 1) = 2
4=ECMA.CEILING(-1.1, -1) = -2
5=ECMA.CEILING(-1.5, -1) = -2
6=ECMA.CEILING(-1.9, -1) = -2
7=ECMA.CEILING(2.5, 2) = 4
8=ECMA.CEILING(-2.5, -2) = -4
9=ECMA.CEILING(8, 1.5) = 9
10=ECMA.CEILING(8.26, 0.05) = 8.3

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