ExcelFlux

FLOOR function

Rounding — a number down, toward zero.

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

Find the full pack multiple that can be filled using the legacy FLOOR function.

A worked example from the workbook

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

Expected result25

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=FLOOR(A7,B7)
Turkish Excel · tr-TR
=TABANAYUVARLA(A7;B7)

Compatibility function for older workbooks.

Worked examples

Find the full pack multiple that can be filled using the legacy FLOOR function.

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 =FLOOR(A7,B7) 25
Record 2 =FLOOR(A8,B8) 30
Record 3 =FLOOR(A9,B9) 0
Microsoft Excel reference