CEILING Function Explained
The CEILING function in Microsoft Excel rounds a number up to the nearest integer or to the nearest multiple of significance. It takes two arguments: the number and the significance. The number is the value to round, and the significance is the multiple to which you want to round the number. The CEILING function rounds the number up, away from zero.
CEILING Function Syntax
CEILING(number, significance)
- number: The number you want to round up to the nearest multiple of significance.
- significance: The multiple to which you want to round number.