For example if you. Excel CEILING Function The CEILING function returns a number rounded up to a nearest multiple of significance. The multiple to use for rounding is provided as the significance argument.
This article describes the formula syntax and usage of the CEILINGMATH function in Microsoft.
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. For example in the second row CEILINGMATH 3852424 385 will be rounded to a multiple of 24 and the result will be divided by 24. If the number is already an exact multiple no rounding occurs and the original number is returned. As a worksheet function the CEILING function can be entered as part of a formula in a cell of a worksheet.