Excel Functions

Excel CEILING Function

Pinterest LinkedIn Tumblr

The CEILING function rounds a given number up to the nearest specified multiple. CEILING works like the ROUND function, but CEILING always rounds up.

Purpose of Excel CEILING Function

When preparing financial models, CEILING helps us round up the numbers as per the requirement

Return value

Returns number rounded up, away from zero, to the nearest multiple of significance.

Syntax

=CEILING (number, multiple)

Arguments

ArgumentsDescriptionRemarks
numberThe number that should be rounded.Mandatory
multipleThe multiple to use when rounding. Mandatory

Usage notes

  • If either argument is non-numeric, CEILING returns the #VALUE! error value.
  • Regardless of the sign of the number, a value is rounded up when adjusted away from zero. If the number is an exact multiple of significance, no rounding occurs.
  • If the number is negative, and the significance is negative, the value is rounded down, away from zero.
  • If the number is negative, and the significance is positive, the value is rounded up towards zero.

Availability

Since 2007 for Windows.
Since 2011 for Mac.

Related Posts

Write A Comment