How to Use Excel CEILING.MATH Function in Office 365?
Tags: excelceilingmathfunc, excelfunctions
Published: 2020-08-27 11:00:12

---
title: How to Use Excel CEILING.MATH Function in Office 365?
published: true
date: 2020-08-26 07:01:21 UTC
tags: ExcelCEILINGMATHFunc,ExcelFunctions,ExcelCEILINGMATHFunc
canonical_url: https://geekexcel.com/how-to-use-excel-ceiling-math-function-in-office-365/
---

## Excel CEILING.MATH Function:

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

In this tutorial, we will guide you to know the usage of **Excel CEILING.MATH Function in Office 365** with its syntax, explanation, 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.MATH Function – Explanation:**

- This function will **round the input number to the nearest integer**  **or to the nearest multiple**.
- For example, **CEILING.MATH(21.6,5)** returns the output value as **25**.

## **Syntax:**

**=CEILING.MATH(number, [significance], [mode])**
- If the significance value is a **negative number** and then it will print the rounded output value **towards zero**.
- If the significance value is a **positive number** and then it will print the rounded output value **away from zero**.

### Argument Explanation:

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

**Significance** – It is optional. The multiple to use when rounding the number. If you omit this option, it will **take 1 as**  **a default value**.

**Mode** – It is optional. It is used for rounding the negative numbers towards or away from zero. By default, **it takes 0**.

### Note:

- If any argument is a non-numeric value (letters and special characters) and then it returns **#VALUE!** Error.
- By default, the significance is +1 for positive input numbers, and -1 for negative input numbers.

## **Examples:**

Let’s see some examples to make it clear.

### Example 1:

- Refer to the below screenshot.
- You can see the input numbers in **Column A** , significance values in **Column B** , and its mode values in **Column C**.
- The rounded output numbers are listed in **Column D**.

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

### Example 2:

- If any of the arguments such as “Number, Significance, Mode” 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-58.png)<figcaption id="caption-attachment-12600">Example 2</figcaption>

## **Summary:**

In this tutorial, you can understand the usage of **Excel CEILING.MATH Function in Office 365** with its syntax, explanation, and examples. Share your **feedback** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Similar Articles:

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

### See Also:

- [How to Use “HEX2OCT Function” in Microsoft Excel 365?](https://geekexcel.com/how-to-use-hex2oct-function-in-microsoft-excel-365/)
- [How to Use “Excel LOG10 Function” in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-log10-function-in-office-365-with-examples/)