Common CEILING questions usually fall into 3 areas: parameter errors, unexpected results, and batch filling. This section covers 3 frequent questions.
FAQ
What should I do if CEILING returns a #VALUE! error?
- Check whether the parameters use the correct data types and do not contain extra spaces or text values.
- Clean the source data if needed, then enter the formula again.
- Make sure the parameter separator is an English comma.
Why does the CEILING result not match what I expected?
- Check whether the formula references the correct cells or ranges.
- Confirm that the related cells are formatted as numbers instead of text.
- Review the parameters again with formula checking tools if needed.
How can I use CEILING in multiple cells at once?
- Enter and confirm the CEILING formula in the first cell.
- Drag the fill handle or copy and paste the formula into the target range.
- Check whether relative and absolute references behave as expected after filling.
Glossary
| Term | Definition |
|---|---|
| CEILING | A rounding-up function that moves a number to the nearest specified multiple. |
| number | The value that CEILING rounds upward. |
| significance | The multiple that determines the rounding target. |