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.
- 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.
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.
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.