FLOOR in Apple Numbers: Round Toward Zero to a Multiple

FLOOR rounds a numeric value toward zero to a multiple of a required factor. For example =FLOOR(73,10) → 70 and =FLOOR(-0.25,-1) → 0, both documented by Apple. [A1]

Copyable formula for English/decimal-point locale:

=FLOOR(12,5)

For 12 and 5 the expected result is 10 (computed independently). [M1]

Keep the largest whole number of factor-sized steps without exceeding the original magnitude. A positive number moves down, and a negative number moves up toward zero. It is not the same as a mathematical floor for every negative input. [A1, M1]

These are multiple-based operations. To round to a chosen number of decimal places instead, use a separate documented function such as ROUND, and do not assume that specifying a factor such as 0.01 is always equivalent at a floating-point edge case. [A6]

=FLOOR(num-to-round, factor)

num-to-round is a required number to reduce toward zero; factor is the required number specifying each whole step. Apple’s help explicitly states that factor must have the same sign as num-to-round. Neither argument is marked optional or given a documented default. Apple’s signature explicitly marks two numeric argument slots. Arguments occur in this order: value first, factor second. This guide does not assume text conversion, missing values, arbitrary array arguments, or extra undocumented options. [A1, A2]

Independent mathematical interpretation

For nonzero inputs with a nonzero factor of matching sign, the independent arithmetic rule is SIGN(value) × floor(ABS(value)/ABS(factor)) × ABS(factor). “floor” here refers to the positive quotient, not to applying INT to a negative original input. This mathematical identity was checked outside Numbers. [A1, M1]

Apple’s current English Formulas and Functions Help, accessed 2026-10-12T04:45:32Z, is the source of this function’s spelling, argument names and sample results. The separately checked Numbers User Guide for Mac identifies the Mac guide as Numbers 15.4. That does not prove this function’s minimum introduction version, old iOS behaviour, or identical iCloud execution. Apple’s shared formula help says it applies to Numbers, Pages and Keynote tables, including Numbers on iPhone, iPad, Mac and in supported cloud use; historical feature parity was not retested. No alternate localized function names were independently verified, so none are presented as aliases. [A1, A4, A5]

The examples assume a locale using periods for decimals and commas for function separators. Apple’s Functions overview explicitly says that when the system uses a comma as the decimal separator, typed function arguments are separated by a semicolon. With num-to-round=12 and factor=5, write =FLOOR(12;5) in such a locale, changing FLOOR to the function on this page. Use the Numbers formula editor if your region inserts punctuation differently; don’t paste formulas containing thousands separators as numeric literals. English function names are case-insensitive per Apple. [A2]

In a Numbers table, B2 means cell B2 of the current table, and B2:B8 is a range. A different table may need a qualified reference such as Table 2::B5; a different sheet can require Sheet 2::Table 2::B5. These are Numbers examples from Apple’s cell reference guide. The Sheet1!B2 notation common in Excel is not the reference style to copy into Numbers. Here each argument is one scalar numeric cell, not a range. [A3]

Validation labels: Apple reference checked = documentation checking. Numerical outputs = independent Python Decimal calculation unless an official Apple example is explicitly identified. No function or screenshot was run or captured in the Apple Numbers app. All worksheet values below are expected, not observed native results.

Create a fresh Numbers table named RoundingPractice and give it at least eight data rows. Set B1 to Value, C1 to Factor, and D1 to FLOOR result. Enter columns B and C from the table below, then enter the expression in D2 and fill D2 through D9. Ensure negative values and negative factors both use the literal minus character -. With the default English punctuation, Numbers should treat each pair as numeric. The results are independent expected results, not observed native execution. [A1, A3, M1]

Row: 2

B: Value
12

C: Factor
5

D formula
=FLOOR(B2,C2)

Expected D
10

Row: 3

B: Value
12.5

C: Factor
5

D formula
=FLOOR(B3,C3)

Expected D
10

Row: 4

B: Value
15

C: Factor
5

D formula
=FLOOR(B4,C4)

Expected D
15

Row: 5

B: Value
-12

C: Factor
-5

D formula
=FLOOR(B5,C5)

Expected D
-10

Row: 6

B: Value
-12.5

C: Factor
-5

D formula
=FLOOR(B6,C6)

Expected D
-10

Row: 7

B: Value
7.1

C: Factor
0.5

D formula
=FLOOR(B7,C7)

Expected D
7.0

Row: 8

B: Value
-3.2

C: Factor
-2

D formula
=FLOOR(B8,C8)

Expected D
-2

Row: 9

B: Value
0.25

C: Factor
1

D formula
=FLOOR(B9,C9)

Expected D
0

To isolate input issues, start by typing =FLOOR(12,5) into any empty cell. Then try =FLOOR(-12,-5) in another; those two standalone formulas do not depend on table names or reference formatting.

Apple’s own short examples

The following are documented examples on the cited official function page, not independently observed Numbers outputs. They were also recomputed mathematically for this review. [A1, M1]

Suppose 73 units are available and each full carton holds 12. =FLOOR(73,12) gives an expected 72 units packed in complete cartons. Dividing that by 12 gives 6 complete cartons, with 1 unit left over. This differs from CEILING(73,12) → 84, the amount needed if you must supply all 73 units in full cartons. Make sure you actually want to discard the incomplete carton rather than include its contents. [A1, M1]

With a policy that counts only completed 0.25-hour blocks, =FLOOR(1.1,0.25) has an expected output of 1.0 hours, while =FLOOR(1.25,0.25) stays 1.25. Rounding logged time affects pay, invoices and compliance, so the relevant business or employment policy must be checked separately. [A1, M1]

For a positive source input B2 and valid factor C2, keep the original in column B and the FLOOR formula in column D. In E2, calculate:

=D2-B2

For the first worksheet row (B2=12, C2=5) the expected adjustment is 10 - 12 = -2. A positive adjustment means the rounded result is larger on the number line; a negative adjustment means smaller. A signed negative input may reverse the relationship between numeric direction and magnitude, so compare absolute magnitudes if that is what your business process cares about.

A second diagnostic is whether a value was already an exact accepted multiple: for positive inputs with whole-number factor, test D2=B2 in a separate cell; this checks whether the rounded output changed, not whether input validation succeeded. These diagnostic expressions are elementary arithmetic and logical comparisons; they have not been tested inside Numbers.

• Negative value: =FLOOR(-12,-5) → expected -10: it moves closer to zero, unlike CEILING(-12,-5) → -15.
• Already a multiple: =FLOOR(15,5) leaves 15 unchanged.
• Contrary signs: =FLOOR(-4,2) violates Apple’s stated sign requirement. Do not assume an Excel error token or automated correction.
• Factor zero and input zero: neither result was natively checked; the retrieved Apple function entry does not establish enough specific behaviour to promise an output. Avoid in examples.
• Non-integral factor: =FLOOR(9,2.5) → 7.5 is an official Apple example.
• INT confusion: Apple FLOOR with negative factor moves a negative input toward zero; INT(-0.25) follows the greatest-integer-not-above interpretation (-1 mathematically). A generic INT replacement can give a different result. [A1, A6, M1]

If your result is not what you expected

1. Check the factor’s sign. For nonzero inputs, the official requirement is same sign as the value. Do not mechanically use positive factors for negative inputs.
2. Check whether you chose the right rounding direction. One of the three functions may be conceptually wrong even when its formula is accepted.
3. Check locale punctuation. A user with comma decimals must use semicolon argument separators when entering formulas manually, according to Apple.
4. Check Numbers table references. Same-table B2 is fine; Excel-style sheet exclamation marks should not be imported uncritically.
5. Check input types and missing data. The official syntax calls for numbers; parse currency-formatted text or blanks explicitly before relying on them. Exact error messages for invalid text were not tested here.
6. Check extreme precision. Output rounding near an exact multiple can be sensitive to stored values. Review the actual cell’s underlying data rather than only its display format.

For the same valid same-sign input pair, you can contrast expected results as follows. These were computed independently using exact decimal arithmetic, not by executing Numbers:

Value: 12

Factor
5

CEILING
15

FLOOR
10

MROUND
10

Value: 12.5

Factor
5

CEILING
15

FLOOR
10

MROUND
15

Value: 15

Factor
5

CEILING
15

FLOOR
15

MROUND
15

Value: -12

Factor
-5

CEILING
-15

FLOOR
-10

MROUND
-10

Value: -12.5

Factor
-5

CEILING
-15

FLOOR
-10

MROUND
-15

Value: 7.1

Factor
0.5

CEILING
7.5

FLOOR
7.0

MROUND
7.0

Value: -3.2

Factor
-2

CEILING
-4

FLOOR
-2

MROUND
-4

Value: 0.25

Factor
1

CEILING
1

FLOOR
0

MROUND
0

CEILING goes outward from zero, FLOOR goes inward toward zero, and MROUND selects the nearest accepted multiple, with exact halfway ties outward. Because these operations answer different questions, swapping one for another can change packing, pricing or reporting decisions even when the formula runs successfully. [A1, A6, M1]

Excel’s official legacy FLOOR(number, significance) documentation likewise uses two arguments and illustrates FLOOR(-2.5,-2) → -2. However Excel’s version-specific documentation discusses sign errors and alternative functions. Verify imported negative-value formulas case by case, rather than treating FLOOR, FLOOR.MATH, and Numbers’ FLOOR as identical. This comparison was checked against Microsoft’s support page only; Excel was not executed. [E1, A1]

For Google Sheets and other spreadsheet programs, verify the official syntax and negative-input behaviour in the target program before migrating calculations. Merely finding a similarly named function does not prove the same optional arguments, locale punctuation, error tokens or numeric precision. Google Sheets was not executed or independently function-audited in this batch.

• Apple: FLOOR reference — primary syntax, required arguments, documented examples and sign rules. [A1]
• Apple: rounding functions comparison — context for selecting the appropriate rounding function. [A6]
• Apple: Functions overview — punctuation, required/optional argument notation and case handling. [A2]
• Apple: refer to cells in formulas — Numbers-style table and sheet references. [A3]
• Microsoft: Excel FLOOR function — source for the explicit Excel comparison; do not interpret as an Apple manual. [E1]

Claim-level evidence IDs

[A1] Apple FLOOR official reference: https://support.apple.com/guide/functions/floor-ffa5883dff/web (syntax, sign rules, meaning, documented outputs; accessed 2026-10-12T04:45:32Z).

[A2] Apple Functions overview: https://support.apple.com/guide/functions/functions-overview-ffa083bef0c/web (argument notation, locale punctuation, case; accessed 2026-10-12T04:45:32Z).

[A3] Apple Refer to cells in formulas: https://support.apple.com/guide/functions/refer-to-cells-in-formulas-ffa550d691/web (same-table cells, range syntax, Table 2::B5 qualified references; accessed 2026-10-12T04:45:32Z).

[A4] Apple Formulas and Functions Help: https://support.apple.com/guide/functions/welcome/web (app/platform scope and catalogue; accessed 2026-10-12T04:45:32Z).

[A5] Apple Numbers User Guide for Mac: https://support.apple.com/guide/numbers/welcome/mac (Mac guide labelled 15.4 at access; other editions unverified; accessed 2026-10-12T04:45:32Z).

[A6] Apple Functions used to round values: https://support.apple.com/guide/functions/functions-used-to-round-values-ffa5bf6af47/web (different rounding families; accessed 2026-10-12T04:45:32Z).

[E1] Microsoft official Excel FLOOR: https://support.microsoft.com/en-us/excel/functions/floor-function (Excel-only signature/behaviour and platform scope; accessed 2026-10-12T04:45:32Z).

[M1] Independent exact-decimal arithmetic: Python stdlib decimal, with input/output rows and method stored in supporting calculation records; verified 2026-10-12T04:45:32Z. Does not prove Numbers’ implementation.

• EVEN — continue with a related Apple Numbers calculation.
• ODD — continue with a related Apple Numbers calculation.
• CEILING — continue with a related Apple Numbers calculation.
• MROUND — continue with a related Apple Numbers calculation.
• ROUND — continue with a related Apple Numbers calculation.

For a software-specific comparison: LibreOffice Calc FLOOR, Apache OpenOffice Calc FLOOR, Gnumeric FLOOR. A shared name does not establish identical argument, error or version behaviour.

The linked official function documentation was reviewed on October 12, 2026. Apple’s Formulas and Functions Help 15.4 identifies the documentation edition, not a minimum Numbers release or a guarantee of historical platform parity. Selected worked examples were checked using independent mathematical or text-processing models; results are expected values, not observations from the spreadsheet application. Native Apple Numbers execution was not performed. Undocumented coercion, exact error messages and platform-specific behaviour remain unverified.

View reproducible example inputs and independent check results. This record is not a native spreadsheet test log.