CEILING Function
The Excel CEILING function is used to round a number up to a multiple of significance. For example, you could round a number up to 2 decimal places, or to the next multiple of 5.
The syntax for the CEILING function is:
=CEILING(number,significance)
Argument |
Purpose |
|---|---|
Number |
The number you want to round up |
Significance |
The multiple of sigificance you want to round the number up to. This must match the sign of the number you are using. For example, you cannot round a negative number to a positive number |
Below are examples of the CEILING function being used to round numbers up to various multiples.
Function |
Result |
|---|---|
=CEILING(A1,0.1) |
5.4 |
=CEILING(A2,1) |
3 |
=CEILING(A3,0.1) |
4.6 |
=CEILING(A4,5) |
25 |
Download the Excel Formulas Ebook for a fast and simple guide to the most useful Excel formulas.
Follow us on
