This post will guide you how to use Google Sheets CEILING function with syntax and examples.

Description

---

The Google Sheets CEILING function returns a given number rounded up to the nearest multiple of a given number of significance. You can use the CEILING function to round up a number to the nearest multiple of a given number.

The CEILING function is a build-in function in Google Sheets and it is categorized as a MATH function.

Syntax

---

The syntax of the CEILING function is as below:

= CEILING (number, significance)

Where the CEILING function arguments are:

• number – This is a required argument. The number that you want to round up.
• significance – This is a required argument. The multiple of significance to which you want to round a number to.

 Note:

• If either number and significance arguments are non-numeric, the CEILING function will return the #VALUE! Error.
• If the number argument is negative, and the significance argument is also negative, the number is rounded down, and it will be away from 0.
• If the number argument is negative and the significance is positive, the number is rounded up towards zero.

Google Sheets CEILING Function Examples

---

The below examples will show you how to use google sheets CEILING Function to round a number up to nearest multiple.

1# to round 4.6 up to nearest multiple of 3, enter the following formula in Cell B1.

=CEILING(4.6,3)

2# to round -4.6 up to nearest multiple of -3, enter the following formula in Cell B2.

=CEILING(-4.6,-3)

3# to round -4.6 up to nearest multiple of 2, enter the following formula in Cell B3.

=CEILING(-4.6,2)

4# to round 2.6 up to nearest multiple of 0.2, enter the following formula in Cell B4.

=CEILING(2.6,0.2)

5# to round 0.26 up to nearest multiple of 0.02, enter the following formula in Cell B5.

=CEILING(0.26,0.02)