ExcelFlux

CEILING.MATH function

Rounding — a number up, to the nearest integer or to the nearest multiple of significance.

Math and trigonometry · Excel 2013+

Where can you use it?

Reporting, manufacturing and engineering teams. When a total, rounding step or numerical transformation is needed, use the example to see which operation fits your inputs.

Scenario in the workbook

Round up to a pack multiple that covers demand. An exact multiple stays unchanged.

A worked example from the workbook

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

Expected result30

See the inputs and instructions for all 3 examples

Syntax

CEILING.MATH(number, [significance], [mode])

Copyable formulas

English Excel · en-US
=CEILING.MATH(27,5)
Turkish Excel · tr-TR
=TAVANAYUVARLA.MATEMATİK(27;5)

Expected result

30

Worked examples

Round up to a pack multiple that covers demand. An exact multiple stays unchanged.

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.MATH(A7,B7) 30
Record 2 =CEILING.MATH(A8,B8) 30
Record 3 =CEILING.MATH(A9,B9) 10
Microsoft Excel reference