CEILING Function

Office 2013 and later

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)

Parameters

Name

Required/Optional

Data Type

Description

number

Required

Number

The number to round.

multiple

Required

Number

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

Show: