## What is CEILING Function in Excel?

The **CEILING** 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 function in excel

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

2. Click on the **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** function

6. Then select **ok**

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

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

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

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

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

**Example 1:**

**How to use CEILING function in excel**

You can see examples of CEILING function below:

**ceiling**(A2,B2) ----->>>>answer is 12
**ceiling**(A3,B3) ----->>>>answer is 12
**ceiling**(A4,B4) ----->>>>answer is 15
**ceiling**(A5,B5) ----->>>>answer is 0
**ceiling**(A6,B6) ----->>>>answer is -15

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

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

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

**CEILING**

It returns a number.

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

**CEILING**

This function has just **2** Argument.

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

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

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

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

```
CEILING(number) = number
```

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

**CEILING**

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

## Errors in **CEILING** function

**CEILING**

## CEILING** related functions :**

- MROUND function
- FLOOR function
- ROUND function
- ROUNDDOWN function
- ROUNDUP function
- INT function
- TRUNC function
- EVEN function
- ODD function