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

• Top 4 Basic Arithmetic Functions Every Google Sheets User Should Know
• 10 Essential Google Sheets Formulas Every User Should Know