Skip to Content

CEILING.MATH

Rounds a number up, to the nearest integer or to the nearest multiple of significance

Syntax

CEILING.MATH(number, [significance], [mode])

Parameters

  • number: Required. The value you want to round
  • significance: Optional. The multiple to which you want to round
  • mode: Optional. For negative numbers, controls whether rounding is toward or away from zero

Example

=CEILING.MATH(6.3)
Returns: NumberSince: Excel 2013