SheetFX
≡
<< Go back to all functions

ISO.CEILING

The ISO.CEILING function in Google Sheets is a mathematical function that rounds a number up to the nearest integer or to the nearest multiple of significance. The ISO.CEILING function is similar to the CEILING.PRECISE function.

Function Syntax and Parameters

Syntax: ISO.CEILING(number, [significance])

Parameters:

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

Step-by-Step Tutorial

  1. Using ISO.CEILING with only a number:

    • Example: =ISO.CEILING(5.7)
    • Result: 6

  2. Using ISO.CEILING with both number and significance:

    • Example: =ISO.CEILING(5.7, 0.5)
    • Result: 6

Use Cases and Scenarios

  1. Financial Calculations: Rounding up currency values to the nearest whole number or specific denomination.
  2. Time Calculations: Rounding up time values to the nearest minute or hour.

Related Functions

  • CEILING: Round a number up to the nearest integer or to the nearest multiple of significance.
  • FLOOR: Round a number down to the nearest integer or to the nearest multiple of significance.

Related Articles