CEILING.PRECISE Function

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

Category

Math & Trig

Available in

Excel 2010+, Microsoft 365

Returns

A number

Want to practice CEILING.PRECISE 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

CEILING.PRECISE always rounds up (towards positive infinity) to a multiple, whatever sign the number or significance has.

It's equivalent to ISO.CEILING and to CEILING.MATH with its default mode.

Syntax

=CEILING.PRECISE(number, [significance])

Arguments

ArgumentRequired?What it does
numberYesThe value to round.
significanceOptionalThe multiple. Default 1; its sign is ignored.

Examples

Example 1 — Up, always

Negative numbers move towards zero because that is “up”.

B2fx=CEILING.PRECISE(A2, 5)
AB
1ValueResult
21215
3-12-10
44.15
=CEILING.PRECISE(A2, 5) Explain

Common mistakes

  • Which one to use? For new work, CEILING.MATH covers everything CEILING.PRECISE does, plus a mode for negatives.

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.