Excel Function : CEILING

Download now!

Excel Function : CEILING


Math and trigonometry


Rounds a number to the nearest integer or to the nearest multiple of significance

Microsoft Excel Reference Page


Syntax and Description of the CEILING Excel Function

Syntax: =CEILING(number,significance) Arguments: number - The number you want to round. significance - The multiple to which you want to round.

About CEILING Excel Function

CEILING rounds a number up to the nearest integer multiple of a specified value. For example, if you want to round up to the nearest multiple of 10, use this formula: =CEILING(A1,10)