The ISO.CEILING function in Google Sheets is a powerful tool designed to round a number up to the nearest integer or specified multiple, adhering to ISO standards. This function is particularly useful for financial and statistical calculations where precise rounding is essential.

Syntax

ISO.CEILING(value, significance)

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

Example #1

ISO.CEILING(4.3, 1)

This function rounds the number 4.3 up to the nearest whole number, which results in 5.

Example #2

ISO.CEILING(4.3, 0.5)

This example rounds 4.3 up to the nearest half, resulting in 4.5.

Example #3

ISO.CEILING(4.3, 2)

Here, 4.3 is rounded up to the nearest multiple of 2, which is 6.

Error handling

• NUM!: This error occurs if the significance is zero or negative, which makes rounding infeasible.
• VALUE!: This error arises when the provided value is non-numeric, indicating that the function requires a numeric argument.

Conclusion

In summary, the ISO.CEILING function is an essential feature in Google Sheets that enables users to perform accurate upward rounding of numbers based on specified criteria. Understanding its syntax and potential error messages can greatly enhance your proficiency in utilizing this function for various applications.