ISO.CEILING Function

Rounds a number up to the nearest multiple (ISO standard version).

Category

Math & Trig

Available in

Excel 2013+, Microsoft 365

Returns

A number

Want to practice ISO.CEILING in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

ISO.CEILING follows the ISO standard for rounding up: always towards positive infinity, ignoring the sign of the significance.

It gives the same results as CEILING.PRECISE and exists so workbooks match the ISO/OpenDocument definition.

Syntax

=ISO.CEILING(number, [significance])

Arguments

ArgumentRequired?What it does
numberYesThe value to round.
significanceOptionalThe multiple. Default 1.

Examples

Example 1 — Rounding up to quarter-hours

Hours worked rounded up to the next 0.25.

B2fx=ISO.CEILING(A2, 0.25)
AB
1HoursBilled
27.17.25
37.57.5
43.84
=ISO.CEILING(A2, 0.25) Explain

Common mistakes

  • Rarely needed. Unless a standard requires it, CEILING.MATH is clearer to readers.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.