How to Use Excel CEILING.PRECISE Function in Office 365?
Tags: excelceilingprecisef, excelfunctions
Published: 2020-08-27 11:00:22

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

## Excel CEILING.PRECISE Function:

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

In this article, we are going to learn the usage of **Excel CEILING.PRECISE Function in Office 365** with its syntax, definition, 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.PRECISE Function -Definition:**

- This function **rounds a number to the given multiple**.
- For example, **CEILING.PRECISE(4.4, 2)** returns the output value **6**.

## **Syntax:**

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

### Argument Explanation:

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

**Significance** – It is optional. The multiple by which the input number is rounded. If you omit this argument, it takes a **default value 1**.

### Note:

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

## **Examples:**

Let’s see some examples.

### Example 1:

- Refer to the below screenshot.
- Here, you can see the input numbers in **Column A** and its significance value in **Column B** , the output is listed in **Column C**.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1-74.png)<figcaption id="caption-attachment-12606">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-59.png)<figcaption id="caption-attachment-12607">Example 2</figcaption>

## **Conclusion:**

In the above article, you can understand the usage of **Excel CEILING.PRECISE Function in Office 365** with its syntax, definition, and clear cut examples. Leave 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/)

### See Also:

- [How to Use Excel LN Function in Office 365? – (with Examples)](https://geekexcel.com/how-to-use-excel-ln-function-in-office-365-with-examples/)
- [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/)