How to Use Excel CEILING Function in Office 365? – {with Examples}
Tags: excelceilingfunction, excelfunctions
Published: 2020-08-27 11:00:00

---
title: How to Use Excel CEILING Function in Office 365? – {with Examples}
published: true
date: 2020-08-26 06:52:19 UTC
tags: ExcelCEILINGFunction,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-excel-ceiling-function-in-office-365-with-examples/
---

## Excel CEILING Function:

![CEILING Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/EXCEL_4eFInW2Zt0.png)<figcaption id="caption-attachment-12612">CEILING Function</figcaption>

In this article, we are going to see the **Excel CEILING Function in Office 365** with its syntax, description, and examples. Let’s see them below!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

 
## CEILING Function – Description:

- This function **rounds a given number to the nearest specified multiple**.
- For example, **CEILING(2.3, 1)** returns the value **3**.
- It is similar to the [**MROUND Function**](https://geekexcel.com/how-to-use-excel-mround-function-in-office-365-with-examples/).

## Syntax:

**=CEILING(number, significance)**

### Argument Explanation:

**Number** – The input number that need to be rounded.

**Significance** – The specified multiple to round the value.

### Note:

- If any argument is a non-numeric value (letters and special characters) and then it returns **#VALUE!** Error.
- If both arguments are negative integers, then the output value is rounded away from zero.
- If the number is negative and the significance is positive and then the output value is rounded towards zero.

## Examples:

Here, we come up with a set of examples to make it clear.

## Example 1:

- Refer to the below example image.
- Here we have given the input numbers in **Column A** , and its significance (multiple) values in **Column B**. The rounded output values are listed in **Column C**.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1-72.png)<figcaption id="caption-attachment-12590">Example 1</figcaption>

## Example 2:

- If any argument is a non-numeric value (letters and special characters) and then it returns **#VALUE!** Error.

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/2-57.png)<figcaption id="caption-attachment-12591">Example 2</figcaption>

### Example 3:

- If both arguments are negative integers, then the output value will **round away from zero**.
- The following image shows the negative input numbers and negative significance values, as a result, the output values are rounded away from zero.

![Example 3](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/3-43.png)<figcaption id="caption-attachment-12592">Example 3</figcaption>

### Example 4:

- If the number is negative and the significance is positive and then the output value will **round towards zero**.
- In the following image, you can see the positive significance values and the negative input numbers, when applying the CEILING function, it will return the output values like below.

![Example 4](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/4-18.png)<figcaption id="caption-attachment-12593">Example 4</figcaption>

From the above examples, you can clearly understand the usage of the **CEILING function**.

## Verdict:

In the above article, you can understand how to use the **Excel CEILING Function in Office 365** with its syntax, description, and examples. Drop your **feedback** in the below comment section. **Thanks for visiting [Geek Excel.](https://geekexcel.com/) Keep Learning!!**

### Similar Articles:

- **ROUND Function in Excel 365**
- [**FLOOR Function in Excel**](https://geekexcel.com/how-to-use-excel-floor-function-in-office-365-with-examples/)

### See Also:

- [How to Use Excel INT Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-int-function-in-office-365-with-examples/)
- [How to Use Excel LOG Function in Office 365? – (with Examples)](https://geekexcel.com/how-to-use-excel-log-function-in-office-365-with-examples/)