ISO.CEILING Function Explained

The ISO.CEILING Function in Microsoft Excel returns the smallest integer greater than or equal to a given number, following the ISO 31-0 standard for rounding. It takes two arguments: the number to be rounded and the significance to which it should be rounded. The significance is the multiple to which the number should be rounded. For example, if the number is 4.2 and the significance is 0.5, the result will be 4.5.

ISO.CEILING Function Syntax

ISO.CEILING(number, significance)

  • number: The number to round up.
  • significance: The multiple to which you want to round number.