The CEILING.MATH function
Rounds a number up to the nearest multiple you choose, such as the next 5, 10 or 0.25. Without a multiple it rounds up to the next whole number.
Syntax
CEILING.MATH(number, [significance], [mode])- number
- The number to round up.
- significance (optional)
- The multiple to round to. Left out, 1.
- mode (optional)
- For negative numbers only. 0 or left out rounds toward zero, any other number rounds away from zero.
Examples
D1=CEILING.MATH(B1/B2)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Items to ship | 130 | 6 | |
| 2 | Items per box | 24 |
B1
=CEILING.MATH(123,25)| A | B | |
|---|---|---|
| 1 | 25 |
In plain words: Round 123 up to the nearest 2multiple of 5.
B1=CEILING.MATH(7.1,0.25)
| A | B | |
|---|---|---|
| 1 | 7.25 |
Questions
What is the difference between CEILING.MATH and ROUNDUP?
ROUNDUP rounds up to a number of decimals, such as 0.1 or 0.01. CEILING.MATH rounds up to any multiple, such as 5, 12 or 0.25.
Should I use CEILING or CEILING.MATH?
Use CEILING.MATH in new sheets. CEILING is the older version; it needs the multiple and handles negative numbers differently.