CEILING function
Summary
Rounds a number to the nearest integer or to the nearest multiple of significance
Syntax
CEILING(number, significance)
The CEILING function syntax has the following arguments:
• Number Required. The value you want to round.
• Significance Required. The multiple to which you want to round.
• Number Required. The value you want to round.
• Significance Required. The multiple to which you want to round.
Example
=CEILING(2.5, 1)
=CEILING(-2.5, -2)
=CEILING(-2.5, 2)
=CEILING(1.5, 0.1)
=CEILING(0.234, 0.01)
=CEILING(-2.5, -2)
=CEILING(-2.5, 2)
=CEILING(1.5, 0.1)
=CEILING(0.234, 0.01)