CEILING Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

CEILING is an Excel Math & Trig function. Rounds a number up to the nearest multiple of a chosen value.

CEILING syntax

=CEILING(number, significance)

CEILING is used in financial models and engineering-style calculations where precise numeric work is needed.

Open the live Excel-style spreadsheet and try CEILING yourself. No Excel install or sign-up needed to start.

What does the CEILING function do in Excel?

Rounds a number up to the nearest multiple of a chosen value.

What is the syntax of CEILING in Excel?

The syntax is =CEILING(number, significance). number: A number to use in the calculation; significance: The multiple to round to.

Where can I practice CEILING online for free?

Open the free live spreadsheet on Cellgrids and try CEILING yourself. No Excel install is needed and you can start without signing up.