ExcelFlux

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

RowAB
6First valueSecond value
7275
8305
9410
Record 1
=CEILING(A7,B7)

Expected result30

See the inputs and instructions for all 3 examples

Syntax

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
Microsoft Excel reference