CEILING function
Rounding — a number to the nearest integer or to the nearest multiple of significance.
Compatibility
Where can you use it?
Teams maintaining legacy workbooks. Compare the example inputs and expected results with the formula in your workbook when checking a calculation made in an older version.
Scenario in the workbook
Round a positive shipment quantity up to a full pack. Signed inputs follow legacy compatibility rules.
A worked example from the workbook
| Row | A | B |
|---|---|---|
| 6 | First value | Second value |
| 7 | 27 | 5 |
| 8 | 30 | 5 |
| 9 | 4 | 10 |
Record 1
=CEILING(A7,B7)Expected result30
See the inputs and instructions for all 3 examplesSyntax
CEILING(number, significance)
Copyable formulas
English Excel · en-US
=CEILING(A7,B7)Turkish Excel · tr-TR
=TAVANAYUVARLA(A7;B7)Compatibility function for older workbooks.
Worked examples
Round a positive shipment quantity up to a full pack. Signed inputs follow legacy compatibility rules.
Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.
| Row | A | B |
|---|---|---|
| 6 | First value | Second value |
| 7 | 27 | 5 |
| 8 | 30 | 5 |
| 9 | 4 | 10 |
| Case | Formula | Expected result |
|---|---|---|
| Record 1 | =CEILING(A7,B7) |
30 |
| Record 2 | =CEILING(A8,B8) |
30 |
| Record 3 | =CEILING(A9,B9) |
10 |