Formulas > =CEILING()

How To Use CEILING() Function in Google Sheets


Rounds a number up to the nearest integer multiple of specified significance.

Common questions about the CEILING formula include:
- What is the syntax of the CEILING formula?
- What parameters does it take?
- When would you use the CEILING formula?

The CEILING formula can be used appropriately in Google Sheets to round a value up to the nearest specified multiple.

The CEILING formula can be commonly mistyped as CEILINGF or CEILLING.

Common ways the CEILING formula is used inappropriately include using it to round numbers down.

Common pitfalls when using the CEILING formula include forgetting to specify a multiple to round up to.

Common mistakes when using the CEILING Formula include forgetting to add quotation marks around the multiple.

Common misconceptions people might have with the CEILING Formula include that it rounds to the nearest integer, when it actually rounds to the nearest multiple.

How To Actually Use CEILING() in Sheets

CEILING(value, [factor])

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the CEILING() formula:

Generate a CEILING() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.