# CEILING Function

The CEILING function in Excel rounds a given number up to the nearest specified multiple. Unlike the MROUND function, the CEILING always will round up. This is demonstrated below in the following examples.

## Syntax:

`=CEILING (number,significance)`

### Arguments:

• number – The number that you want to round
• significance (multiple) – The specified multiple when rounding.

## CEILING Function Example – Round to 10

Let’s look at the following example of using this Function. We will review how to round to the nearest 10th. We use the following function.

`=CEILING(A5,B5)`

Result from our function above. As you can see, our number is rounded up to the 10th.

## Round pricing to \$0.99

Everyone knows that the greatest marketing gimmick of all time is setting the purcachase price to \$0.99. Let’s review how this works in Excel.

`=CEILING(A10,B10)-0.01`

By using the formula above, Excel rounds up to the nearest 1 multiple, then subtracts .01 from the total. This gives us our desired result.

## Rounding Functions in Excel

ROUND Function – Rounds to a specified number of digits.

ROUNDUP Function – Rounds numbers up a specified decimal place.

ROUNDDOWN Function – Returns a number rounded down to a specified number of places.

FLOOR Function – Rounds a given number down to the nearest specified multiple

MROUND Function – Round a number up or down to a given multiple.

CEILING Function – Rounds a given number up to the nearest specified multiple.

INT Function – Rounds a number down to the nearest integer.

TRUNC Function – Returns a truncated number based on a specified number of digits.

### HLOOKUP Function in Excel

HLOOKUP Function Glossary What is HLOOKUP? HLOOKUP Example Exact Match vs Approximate Match (False vs True) HLOOKUP from another Workbook