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.