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.