Wauvel

Excel like a finance pro.

← The library

Math function

ISO.CEILING

Rounds a number up to the nearest multiple of significance using the ISO rule, ignoring the sign of significance.

Rarely usedDifficulty 1250 · ProficientUsage rank #284 of 520
Practice · 2 questions →

When to use it

Same as CEILING.PRECISE: rounds up toward positive infinity to a multiple, ignoring the sign of significance. Provided for ISO naming compatibility.

The shape of it

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

Worked examples

  • Whole number

    =ISO.CEILING(4.3) → 5

    Whole number.

  • Negative input

    =ISO.CEILING(-4.3,2) → -4

    Toward positive infinity.

  • Multiple of seven

    =ISO.CEILING(22,7) → 28

    Next multiple of 7.

Worth knowing

  • Use CEILING.MATH in new work; this exists for spreadsheets exchanged with other ISO-compliant tools.
  • The sign of significance is ignored.
  • Significance defaults to 1.

Where it goes wrong

  • Not in Excel 2007 or earlier.
  • Autocomplete lists it separately from CEILING, which confuses people looking for one rounding function.

Related

SUMSUMIFSUMIFSROUNDABSSUMPRODUCT

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.