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)
CEILING Function

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

Ceiling Function 2

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
Ceiling Function Pricing to .99

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.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top
Send this to a friend