CEILING.MATH Function
Rounds a number up to the nearest integer or multiple.
Category
Math & Trig
Available in
Excel 2013+, Microsoft 365
Returns
A number
Want to practice CEILING.MATH 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.MATH is the modern way to round up to a multiple. Leave significance out and it rounds up to the next whole number.
For negative numbers it rounds towards zero by default (−4.3 → −4); set mode to 1 to round away from zero instead.
Syntax
=CEILING.MATH(number, [significance], [mode])
Arguments
| Argument | Required? | What it does |
|---|---|---|
| number | Yes | The value to round. |
| significance | Optional | The multiple to round up to. Default 1. |
| mode | Optional | For negative numbers: 0 (default) rounds towards zero, any other value rounds away from zero. |
Examples
Example 1 — Rounding up to $10 bands
Group order values into $10 price bands.
B2fx=CEILING.MATH(A2, 10)
| A | B | |
|---|---|---|
| 1 | Order value | Band |
| 2 | 42.5 | 50 |
| 3 | 60 | 60 |
| 4 | -17 | -10 |
=CEILING.MATH(A2, 10) Explain
Common mistakes
- Expecting −20 for −17. By default negatives round towards zero. Add mode 1: CEILING.MATH(-17, 10, 1) returns −20.
Notes
- Related functions: FLOOR.MATH, CEILING, MROUND, ROUNDUP.

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.