The function was introduced in MS Excel 2013. Positive numbers with decimal portions are rounded up to the nearest integer eg. CEILINGPRECISE was introduced in MS Excel 2010 to replace the CEILING function.
For further details and examples of the Excel CeilingMath function see the Microsoft Office website.
Likewise it is also used to roundup the dates. And we wish to highlight the rows in the given groups of 3 we can use the excel formula ISEVEN CEILING ROW -1933 in conditional formatting and output will be as follows. CEILINGnumber significance Where thenumber is your starting pointand the significance is the multipleyou want your number rounded down to for FLOOR or up to for CEILING. 63 is rounded up to 7 and negative numbers with decimal portions are rounded toward zero eg.