keyboard_arrow_left back to knowledge base

Rounding up calculator results to the next integer

Using the Ceil() function, you can round up the results of a formula to the next integer. It’s a useful tool for when the results of formulas have to be integers and in this case, the Ceil() function is used to round up the results to the next integer. For example: if the result of a formula is 87.3, it will be rounded up to the next integer which is 88.

After creating the wanted formula and writing it in the formula editor, write down Ceil before the formula and put it in brackets. So it should look like this: if the formula is 2.2+2.3 then you should write it like this Ceil(2.2+2.3). Now, the result will be rounded up from 4.5 to 5.

NOTE: To use the standard way of rounding up numbers, which is if the result is 4.2 then it will be rounded up to 4 and if the result is 4.5 or higher the result will be rounded up to 5, use the Round() function in the same way as Ceil().