CEILING
Rounds a number to the nearest integer or to the nearest multiple of significance.
CompatibilityCompatibility / LegacyLegacy / Older Versions
What it does
Rounds a number up (away from zero) to the nearest multiple of significance.
Syntax
CEILING(number, significance)
Arguments
number(number) — Value to round.significance(number) — The multiple to round to.
Examples
Round up price
Round 2.50 to nearest 1.
FORMULA
=CEILING(2.50, 1)
RESULT
3
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Price | Signif |
| 2 | 2.5 | 1 |