Ceiling

Syntax

Ceiling(Value, Precision)

Value. Rounded value.

Precision. The multiple, to which you want to round.

NOTE. To determine the parameter, specify either the number or the address of the cell where it is located.

It returns the result of rounding the value up to the nearest integer or to the nearest multiple of significance.

Formula	Result	Description
=Ceiling(-2.1, -0.5)	-2,5	It rounds the 2.5 number to the nearest number divisible by -0.5.
=Ceiling(B6,C6)	2	Rounds the number from the B6 cell to the nearest number divisible by the value from the C6 cell. The B6 cell contains the number 1.1, the C6 cell contains 1.1.
=Ceiling(5.8, -0.1)	#NUMBER!	It returns an error because the numbers 5.8 and -0.1 have different signs.