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
| Argument | Required? | What it does |
|---|---|---|
| number | Yes | The value to round. |
| significance | Optional | The 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)
| A | B | |
|---|---|---|
| 1 | Hours | Billed |
| 2 | 7.1 | 7.25 |
| 3 | 7.5 | 7.5 |
| 4 | 3.8 | 4 |
=ISO.CEILING(A2, 0.25) Explain
Common mistakes
- Rarely needed. Unless a standard requires it, CEILING.MATH is clearer to readers.
Notes
- Related functions: CEILING.PRECISE, CEILING.MATH.

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.