In this article:

How to Use the Google Sheets CEILING Function (2024 Guide)

May 8, 2024

What is the CEILING Function in Google Sheets?

This function rounds a number up to the nearest multiple of significance that you specify. The basic syntax is:

CEILING(value, [factor])


  • value is the number you want to round up.
  • factor (optional) is the multiple to which you want to round the value. If omitted, it defaults to 1.

For example: 

To round 4.3 up to the nearest whole number, you would use: =CEILING(4.3) which returns 5.

To round 4.3 up to the nearest 0.5, you would use: =CEILING(4.3, 0.5) which returns 4.5.

To round -2.5 up to the nearest 2, you would use: =CEILING(-2.5, 2) which, in Google Sheets, returns -2.

Note that CEILING in Google Sheets behaves differently with negative numbers compared to some other spreadsheet software. It rounds away from zero, making the result closer to zero than the original number, unlike the Excel version that rounds negative numbers away from zero.

How to Use the CEILING function in Google Sheets

Follow the steps below to use the CEILING function in Google Sheets.

Step 1: Select a Cell

Click on the cell where you want the result to appear.

Step 2: Enter the Ceiling Function

Type the CEILING function with the appropriate value and factor. For example: =CEILING(A1, 0.5).

google sheets ceiling

Press Enter, and the cell will display the rounded-up number.

ceiling google sheets

The CEILING function is very useful for rounding numbers up in financial calculations, setting price points (e.g., rounding to the nearest 0.99), or anytime you need to adjust numbers to specified intervals.

We hope that this article has helped you and given you a better understanding of how to use the CEILING function in Google Sheets. If you enjoyed this article, you might also like our articles on how to set up a custom number format for millions in Google Sheets and how to use the FLOOR function in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->