Last modified: March 09, 2015
Applies to: Office 2013 | Visio 2013
In this article Syntax Remarks Example 1 Example 2 Example 3
Rounds a number away from 0 (zero) to the next instance of multiple. If multiple is not specified, the number rounds away from 0 to the next integer.
CEILING(number, multiple)
Name
Required/Optional
Data Type
Description
number
Required
Number
The number to round.
multiple
The multiple to round to.
Number and multiple must have the same signs, or a #NUM! error is returned. If either number or multiple cannot be converted to a value, a #VALUE! error is returned. If either number or multiple is 0, the result is 0.
CEILING(3.7)
Returns 4
CEILING(-3.7)
Returns -4
CEILING(3.7, 0.25)
Returns 3.75