Excel like a finance pro.

The functions, VBA, and shortcuts a finance operator actually uses — curated, with CFO examples. Prefer them pre-built? Grab a ready-made model.

← The library

Math function

CEILING.PRECISE

Rounds a number up to the nearest multiple of significance, always toward positive infinity regardless of sign.

Rarely usedDifficulty 1200 · ProficientUsage rank #260 of 520

Practice · 2 questions →

When to use it

Rounds up toward positive infinity to a multiple of significance, ignoring the sign of significance. A stepping stone between CEILING and CEILING.MATH.

The shape of it

Syntax: =CEILING.PRECISE(number, [significance])

Worked examples

Whole number
=CEILING.PRECISE(4.3) → 5
Default significance 1.
Negative input
=CEILING.PRECISE(-4.3) → -4
Toward positive infinity, so less negative.
Multiple
=CEILING.PRECISE(4.3,2) → 6
Multiple of 2.

Worth knowing

Identical to ISO.CEILING.
CEILING.MATH with mode 0 gives the same results and is the current name.
Negative significance is treated as positive.

Where it goes wrong

Not available in Excel 2007 or earlier.
People expecting away-from-zero for negatives get the opposite.

SUM SUMIF SUMIFS ROUND ABS SUMPRODUCT

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.