# Google Sheets CEILING Function

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

Table of Contents

## 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)`