ROUNDDOWN: Rounds toward zero, retaining only the specified decimal places. With zero digits, =ROUNDDOWN(-3.74,0) is -3, not -4. The name ‘down’ describes the magnitude being reduced, not a move toward negative infinity.

Official syntax: ROUNDDOWN(num-to-round, digits) — Apple’s ROUNDDOWN reference (current English Functions Help 15.4, accessed October 11, 2026). This guide describes the documented behavior, not an observation from an Apple Numbers application session.

Use ROUNDDOWN to deliberately discard fractional precision without increasing a numeric magnitude. For positive measurements it can estimate complete usable units, but the negative-value rule matters for debts, adjustments, temperature logs, and signed quantities.

Numbers stores numeric cell values separately from how many decimal places are shown. When a formula actually rounds or truncates a number, downstream arithmetic uses the formula result; changing display formatting alone does not change the underlying numeric value. In particular, distinguish negative inputs from positive values before choosing a rounding rule.

=ROUNDDOWN(num-to-round, digits)

ROUNDDOWN requires both arguments, even when digits is zero; do not omit the second argument. With a comma decimal separator, use =ROUNDDOWN(B2;C2). Apple’s English documentation uses a comma between function arguments and a decimal point for numbers such as 3.74. Numbers’ localized argument separator can change: Apple’s Functions overview says use semicolons between arguments when the decimal separator is a comma. Translate both your decimal notation and argument separator for your locale instead of pasting an English formula unchanged.

Official behavior worth checking: Apple illustrates ROUNDDOWN(1.23456,3) → 1.234 and ROUNDDOWN(1111.222,-2) → 1100.

Create an Apple Numbers table named Rounding Lab. Set row 1 as a header row. Enter the inputs below as numeric values, not numeric-looking text. Use these headings: A = Case, B = Input, C = Digits, D = Result. Columns A and C are descriptive/argument fields; you do not type the formula text in the same cell as the input.

Column B is the value, column C contains the digit position, and column D contains =ROUNDDOWN(B2,C2). A digit argument of 0 produces whole-number results.

Copy the first formula in D2 down through D9, allowing relative row references to adjust. For the INT case, use =INT(B2) through =INT(B9) and ignore column C. For each other function, use =ROUNDDOWN(B2,C2) through =ROUNDDOWN(B9,C9).

Validation disclosure: Each expected value above was independently computed with Python’s decimal.Decimal fixed-point arithmetic and an explicit directional rounding rule. Those are mathematically expected outputs, not native Numbers outputs; automatic type conversion, locale interpretation and imported values still require testing in Numbers. A value shown as 13 could be formatted as 13.00 without changing the underlying number.

=ROUNDDOWN(-3.74,0) → -3 while =INT(-3.74) → -4. ROUNDUP(-3.74,0) → -4. For positive 3.74, both INT and ROUNDDOWN(…,0) are 3; do not assume they are interchangeable across signs.

The four distinct operations matter when results cross zero. INT uses floor (toward negative infinity); ROUNDUP means away from zero, ROUNDDOWN means toward zero, and TRUNC discards digit positions toward zero. The last two give the same numeric outputs for the ordinary examples in this guide, but one must still respect their specific documented argument requirements. For side-by-side Apple context consult the official rounding-functions comparison.

Complete units from a positive ratio

If 17.5 litres are in B12 and a full container holds 4 litres (C12), =ROUNDDOWN(B12/C12,0) yields 4 full containers. This assumes both quantities are nonnegative and capacity is greater than zero. It is not a substitute for calculating how many containers you must purchase to hold all the liquid—that would call for a round-up strategy.

Limit a display-bound ratio without rounding upward

If B13 contains 0.87654, =ROUNDDOWN(B13,3) gives 0.876 as a numeric value. Formatting B13 to three decimal places may visually display 0.877 while leaving its underlying value unchanged. ROUNDDOWN instead changes the result used by downstream formulas.

Work with signed data carefully

For -17.5 in B14, =ROUNDDOWN(B14,0) returns -17, rather than -18. In signed inventory adjustments or debts, reducing the magnitude might be misleading; specify the business rule before choosing rounding direction.

• Negative inputs return a less-negative number: ROUNDDOWN(-2.8,0) is -2, because rounding is toward zero. Use INT for a mathematical floor.
• Digits argument left out: Apple’s reference specifies two arguments; use ROUNDDOWN(B2,0) for integer precision.
• Zeros seem to disappear: 13.00 and 13 are the same numeric result; set cell formatting when a fixed number of shown decimals matters.
• Need a multiple such as 5 or 25: digits values only select powers of ten; investigate other functions or scaling with caution.
• Unrecognized syntax or wrong result: confirm the formula begins with =, the correct number of arguments was entered, and B2 contains a number rather than text that happens to look numeric. Use the formula editor to confirm the argument separators for your locale.
• The cell reference comes from another table: Apple’s reference style may require a qualified address such as Rounding Lab::B2 (or a sheet-qualified form). Selecting the referenced cell via the formula editor is preferable to manually guessing punctuation.
• Floating-point and extreme-value edge cases: this guide has not exercised the actual Apple Numbers numeric engine. Do not infer exact treatment of values near its precision limits, nonnumeric operands, very large digit counts, or other undocumented coercion rules from the ordinary examples.
• No platform test: native Numbers on Mac, iPad/iPhone, and web/iCloud versions were not tested. The Apple Functions Help 15.4 documentation edition does not establish the first product release in which each function was available.

For debugging, isolate the smallest failing call and compare its input types and argument count to Apple’s value types and the exact function page before adding nested formulas.

A same-table formula refers to B2; a different table may need Rounding Lab::B2; other-sheet references can include the sheet and table using ::, as documented in Apple’s cell-reference guide. Relative references move when copied downward; absolute references require explicit locking in the formula editor.

Cell format controls visible decimal places, thousands separators and decimal symbols, not the logical definition of rounding. For examples using a decimal comma, enter 3,74 as a localized numeric input and use a semicolon to separate multiple function arguments. Re-check converted formulas after CSV imports or workbook transfers. The examples were checked against documentation, not rendered on each locale/platform.

Microsoft Excel documents a function named ROUNDDOWN in its official function reference. Google Sheets lists corresponding functions in its official functions list. Similar names do not prove identical coercion, text-input recognition, locale delimiters, precision, or error handling. Transfer the test data above to the target application and independently inspect results before using it for business or regulated calculations.

• INT: Apple Functions Help — Returns the greatest integer that is less than or equal to its numeric input. For negative value.
• ROUNDUP: Apple Functions Help — Rounds a numeric value away from zero at the requested precision. For example, `=ROUNDUP(-3.74,0.
• TRUNC: Apple Functions Help — Discards digit positions beyond the requested precision toward zero. =TRUNC(-3.74) gives *-3.
• Apple numeric argument/value types — argument-type distinctions.
• Apple functions overview — formula syntax and localized separator behavior.

These are official external help links, links to official vendor documentation.

• Apple Numbers — function documentation
• Apple’s Functions overview
• official rounding-functions comparison
• Apple’s value types
• Apple’s cell-reference guide
• INT: Apple Functions Help
• ROUNDUP: Apple Functions Help

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in Apple Numbers.

• No genuine Apple Numbers screenshots are included; this guide does not use mock application images.