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
| Argument | Required? | What it does |
|---|---|---|
| number | Yes | The value to round. |
| significance | Optional | The 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)
| A | B | |
|---|---|---|
| 1 | Value | Result |
| 2 | 12 | 15 |
| 3 | -12 | -10 |
| 4 | 4.1 | 5 |
=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
- Related functions: CEILING.MATH, ISO.CEILING, FLOOR.PRECISE.

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.