CEILING Function Google Sheets

What Is CEILING Function In Google Sheets?

CEILING function in Google sheets is used to find the round up of a numeric value in Google sheets. Using this function, we can get the nearest integer multiple of the number in the given data.

For example, consider the below table showing data and round up value in columns A and B respectively.

Now, let us find the round up value using the CEILING function.

The steps are:

Step 1: To begin with, we need to insert the data in the spreadsheet. In this example, the data is inserted in A1:C2. Next, select the cell where we want to find the result. In this example, it is cell C2.

Step 2: Next, insert the CEILING function formula.

So, the formula is =CEILING(A2,B2)

Step 3: Press Enter key.

We can see the result as shown in the below image.

Now, we can see the result in cell C2.

Similarly, we can get the round up value using CEILING function.

In this article, let us learn how to use CEILING Google sheets function with detailed examples.

CEILING() Google Sheets Formula

CEILING function in Google sheets is an inbuilt function.

The formula or syntax of CEILING function is =CEILING(value,factor)

where,

• value is the number or data we need to round up
• factor is the multiple which we use to round the value

Both are mandatory arguments.

How To Use CEILING Google Sheets Function?

The steps to round up a value using CEILING Function are:

Step 1: To begin with, we need to insert the data in the spreadsheet. Next, select the cell where we want to find the result.

Step 2: Next, insert the CEILING function formula.

Step 3: Press Enter key.

We will be able to see the result.

Similarly, we can get the round up value using CEILING function in Google sheets.

Example

For example, consider the below table showing data and round up value in columns A and B respectively.

Now, let us find the round up value using the CEILING function.

The steps are:

Step 1: To begin with, we need to insert the data in the spreadsheet. In this example, the data is inserted in A1:C3. Next, select the cell where we want to find the result. In this example, it is cell C2.

Step 2: Next, insert the CEILING function formula.

So, the formula is =CEILING(A2,B2)

Step 3: Press Enter key.

We can see the result as shown in the below image.

Now, we can see the result in cell C2. Next, using Autofill we can find the result in cell C3, as shown in the below image.

Likewise, we can get the round up value using CEILING function.

Examples

Example #1 – Round Up To The Next Nickel

For example, consider the below table showing data and round up values in columns A and B respectively.

Now, let us learn how to round up to the next nickel using the CEILING function.

The steps are:

Step 1: To begin with, we need to insert the data in the spreadsheet. In this example, the data is inserted in A1:C6. Next, select the cell where we want to find the result. In this example, it is cell C2.

Step 2: Next, insert the CEILING function formula.

So, the formula is =CEILING(A2,B2)

Step 3: Press Enter key.

We can see the result as shown in the below image.

Now, we can see the result in cell C2. Next, using Autofill we can find the result in other cells, as shown in the below image.

Similarly, we can get round up to the next nickel using CEILING function.

Example #2 – Round Up To The Nearest Half-Hour

For example, consider the below table showing data and round up value in columns A and B respectively.

Now, let us learn how to round up to the nearest half-hour using the CEILING function.

The steps are:

Step 1: To begin with, we need to insert the data in the spreadsheet. In this example, the data is inserted in A1:C4. Next, select the cell where we want to find the result. In this example, it is cell C2.

Step 2: Next, insert the CEILING function formula.

So, the formula is =CEILING(A2,B2)

Step 3: Press Enter key.

We can see the result as shown in the below image.

Now, we can see the result in cell C2. Next, using Autofill we can find the result in other cells, as shown in the below image.

Similarly, we can round up to the nearest half-hour using CEILING function.

Example #3 – Round With Different Factors

For example, consider the below table showing data and round up value in columns A and B respectively.

Now, let us learn how to round with different factors using the CEILING function.

The steps are:

Step 1: To begin with, we need to insert the data in the spreadsheet. In this example, the data is inserted in A1:C4. Next, select the cell where we want to find the result. In this example, it is cell C2.

Step 2: Next, insert the CEILING function formula.

So, the formula is =CEILING(A2,B2)

Step 3: Press Enter key.

We can see the result as shown in the below image.

Now, we can see the result in cell C2. Next, using Autofill we can find the result in other cells, as shown in the below image.

Similarly, we can round with different factors using CEILING function in Google sheets.

Important Things To Note

• CEILING function in Google sheets is used to round up a numeric value.
• Similar to CEILING functions, there are other functions in the same category.
• They are:
  • CEILING.MATH
  • CEILING.PRECISE

Frequently Asked Questions

Download Template

This article must help understand CEILING Function Google Sheets with its formula and examples. You can download the template here to use it instantly.

Recommended Articles

Guide to What is the CEILING Function in Google Sheets. We discuss how to use it and its syntax along with detailed examples. You can learn more from the following articles.

NA Google Sheets

Show Formula In Google Sheets

Sentence Case In Google Sheets–