CEILING function

CEILING(number, significance?) CEILING(number; significance?)

number — Number or { Number }

The number to be rounded.

significance — Number or { Number } (optional)

The multiple to which the input number should be rounded. If omitted, it is assumed to be 1.

Returns — Number or { Number }

The rounded number.

Returns a number rounded up to the nearest multiple of another number. CEILING(22)CEILING(22) returns 22, but CEILING(22.1)CEILING(22,1) returns 23.

If a significance is not specified, it is assumed to be 1, meaning that the returned value is an integer. CEILING(22.1, 5)CEILING(22,1; 5) returns 25, because 25 is the nearest multiple of 5 that 22.1 can be rounded up to.

Negative numbers are rounded towards zero, unless both parameters are negative, in which case numbers are rounded away from zero. That means that CEILING(-22.1, 5)CEILING(-22,1; 5) returns -20, not -25. Use CEILING.MATH instead to customize this behavior.

Examples

CEILING(22)CEILING(22)

Returns 22, assuming a significance of 1.

CEILING(22.1)CEILING(22,1)

Returns 23, assuming a significance of 1.

CEILING(22.1, 1)CEILING(22,1; 1)

Returns 23, with the significance given as the second parameter.

CEILING(22.1, 5)CEILING(22,1; 5)

Returns 25, with the significance given as the second parameter.

CEILING(-22.1, 5)CEILING(-22,1; 5)

Returns -20, because negative numbers are rounded toward zero. Use CEILING.MATH instead to customize this behavior.

CEILING({ 22, 22.1 })CEILING({ 22; 22,1 })

Returns the array { 22, 23 }{ 22; 23 }.

CEILING({ 22, 22.1 }, 1)CEILING({ 22; 22,1 }; 1)

Returns the array { 22, 23 }{ 22; 23 }.

CEILING({ 22, 22.1 }, 5)CEILING({ 22; 22,1 }; 5)

Returns the array { 25, 25 }{ 25; 25 }.

CEILING({ 22, 22.1 }, { 5, 1 })CEILING({ 22; 22,1 }; { 5; 1 })

Returns the array { 25, 23 }{ 25; 23 }. 22 uses a significance of 5 and 22.1 uses a significance of 1.