## What is CEILING.MATH Function in Excel?

The **CEILING.MATH** function is one of the math functions of Excel.

It Rounds a number up, to the **nearest integer **or to the **nearest multiple** of significance.

We can find this function in **Math & trig** category of insert function Tab.

## How to use CEILING.MATH function in excel

- Click on an
**empty cell**(like F5 )

2. Click on **fx icon** (or press** shift+F3**)

3. In the **insert function tab **you will see all functions

4. Select **math and trig** category

5. Select **CEILING.MATH** function

6. Then select **ok**

7. In the function arguments Tab you will see ** CEILING.MATH** function

8. Number is the **value you want to round**.

9. Significance is **the multiple** to which you want to round

10. Mode is when **given and nonzero this function** will round away from zero

11. You will see **results **in the formula result section

## Examples of **CEILING.MATH** function in Excel

**Example 1:**

**How to use CEILING.MATH function in excel**

You can see examples of CEILING.MATH function below:

**ceiling.math**(A2,B2) ----->>>>answer is 6
**ceiling.math**(A3,B3,C3) ----->>>>answer is -34
**ceiling.math**(A4,B4) ----->>>>answer is -3
**ceiling.math**(A5,B5,C5) ----->>>>answer is 12
**ceiling.math**(A6,B6,C6) ----->>>>answer is -2
**ceiling.math**(A7,B7,C7) ----->>>>answer is 0

## What is the purpose of **CEILING.MATH** function?

**CEILING.MATH**

It Rounds a number up, to the **nearest integer **or to the **nearest multiple** of significance.

## What is the Return value of **CEILING.MATH** function?

**CEILING.MATH**

It returns a number.

## How many arguments does **CEILING.MATH** function have?

**CEILING.MATH**

This function has just **3** Argument.

The **argument **of CEILING.MATH function is **number**.

Number is the **value you want to round**.

Significance is **the multiple** to which you want to round.

Mode is when **given and nonzero this function** will round away from zero.

The argument of CEILING.MATH function is **required **and not optional.

```
CEILING.MATH(number) = number
```

## Which version of excel supports **CEILING.MATH** function?

**CEILING.MATH**

This function is available for all excel **versions **(2003-2019)

## Errors in **CEILING.MATH** function

**CEILING.MATH**