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 |
