CEILING

Description

CEILING rounds a number up to the nearest multiple of a specified value.

Syntax

CEILING (number, precision )

Remarks

With positive numbers, the value is always rounded up. If both, number and precision are negative, the value is rounded down.

If the number or significance is non-numeric, the #VALUE! error is returned. Arguments having opposite signs return the #NUM! error.

Examples

This function returns 1.25:

CEILING(1.23459, .05)

This function returns 150:

CEILING(148.24, 2)

This function returns -3000:

CEILING(-2987, -30)

These functions return 0:

CEILING(3000, 0)

CEILING(-3000, 0)

 Note:

If an Invalid formula syntax warning appears, check whether the comma is set as the list separator in your regional settings on the Windows Control Panel. If a different character is set as the list separator, use this character in the above examples in place of the comma. (Windows XP: Access the Windows Control Panel and select Regional and Language Options. On the Regional Options tab page, click Customize. On the Numbers tab page, check which character is the default list separator on your computer. Use this character in the above examples instead of the comma.

Also, see

EVEN

FLOOR

INT

ODD

ROUND

TRUNC