EVEN Function in Apple Numbers: Round Away from Zero to an Even Integer

EVEN rounds a number away from zero to an even integer. For example, =EVEN(-2.5) has an expected result of −4, not −2. Positive and negative inputs are treated symmetrically by magnitude. This is an even-integer function, not a Boolean test for whether a number is even ([A1]).

Official syntax (Apple Formulas and Functions Help 15.4):

=EVEN(num-to-round)

Required input: num-to-round is a single numeric expression, literal, or numeric cell reference. Apple documents one required argument, no optional arguments, and no defaults for this function. The argument’s type matters: a visually number-like text cell is not equivalent to a verified numeric input. Syntax, argument names, and documented behavior are sourced from the official Apple EVEN reference ([A1]).

Function name, release, references, and locale

• Name/aliases: EVEN is the English name present in Apple’s checked function catalogue; no distinct official alias was established in that English entry. Do not create separate pages for localized labels or version variants without evidence ([A2]).
• Documentation scope: The reference is the public Apple Formulas and Functions Help edition 15.4, accessed on 2026-10-12 UTC. A help-edition number is not the minimum supported Numbers application version. We did not establish introduction dates, identical platform support, or localized aliases across Mac/iPhone/iPad/web ([A1], [A2]).
• Decimal conventions: English formula examples use . as the decimal point. Apple documents using semicolons between arguments when a decimal comma is configured. This function has only one argument, so there is no separator inside =EVEN(num-to-round); the decimal literal 2.5 may need localized entry as 2,5. Insert cells using the formula editor to avoid mistaken punctuation ([A3]).
• Cell references: In the same table, B2 is a relative reference; when a formula references another table, Numbers uses a qualified token such as DataTable::B2. A reference on another sheet can include its sheet and table names, and selection from the editor is safer than manually constructing a name with spaces. Verify the actual table/sheet names before copying a cross-table formula ([A4]).

Official supporting guidance: Function syntax, capitalization and regional separators; Refer to cells in formulas.

Create a table named ParityRounding with a header row: A = Case, B = Input (number), C = Rounded result, D = Unchanged?. Type these numeric literals into B2:B11; do not put quote marks around them. In C2 enter =EVEN(B2) and fill down through C11. In D2 enter =C2=B2 and fill down. The C results below are mathematically computed expectations, not observations from Numbers. Format C as a number with zero decimals and B with at least one decimal ([M1]).

Row: 2

B: numeric input
-3.2

C: formula
=EVEN(B2)

C: expected output
-4

Row: 3

B: numeric input
-3

C: formula
=EVEN(B3)

C: expected output
-4

Row: 4

B: numeric input
-2

C: formula
=EVEN(B4)

C: expected output
-2

Row: 5

B: numeric input
-0.1

C: formula
=EVEN(B5)

C: expected output
-2

Row: 6

B: numeric input
0

C: formula
=EVEN(B6)

C: expected output
0

Row: 7

B: numeric input
0.1

C: formula
=EVEN(B7)

C: expected output
2

Row: 8

B: numeric input
1

C: formula
=EVEN(B8)

C: expected output
2

Row: 9

B: numeric input
2

C: formula
=EVEN(B9)

C: expected output
2

Row: 10

B: numeric input
2.5

C: formula
=EVEN(B10)

C: expected output
4

Row: 11

B: numeric input
3.2

C: formula
=EVEN(B11)

C: expected output
4

If B2 is negative or zero, confirm it is truly a numeric cell before drawing conclusions from a display. To test the algebra without a data table, Apple’s published standalone examples are also useful. Decimal localization can affect what you type into cells but not the mathematical target of the function.

Official single-cell examples and rounding direction

Apple documents: EVEN(1) → expected 2; EVEN(2) → 2; EVEN(2.5) → 4; EVEN(-2.5) → −4; and EVEN(0) → 0 ([A1]). For EVEN(-3.2), independent math predicts −4, because −4 is the first even integer with absolute magnitude at least 3.2.

Why EVEN does not behave like ordinary nearest-integer rounding

EVEN moves away from zero to the first even integer in that direction. Consequently =EVEN(2.5) has an expected result of 4, =EVEN(2) stays 2, and =EVEN(-2.5) gives −4. Apple explicitly documents those cases ([A1], [M1]). This is different from ROUND, ROUNDUP, or INT: the result must have even parity, not merely zero decimal places. For a negative number such as −0.1, the expected result is −2, since −0 would not be a nonzero away-from-zero even step ([M1]).

Batch items in packs of two — example

Suppose column B records nonnegative single-unit demand counts, while orders must be an even number of units for pair packaging. In C2 type =EVEN(B2). If B2 is 7, the expected packable quantity is 8; if B2 is 8, the expected result is 8. Column D can show the extra units by =C2-B2, which gives 1 for a demand of 7. This use case presumes demand cells hold nonnegative quantities; for returns or corrections represented by negative values, a business rule may require different handling. Do not assume the sign-preserving negative output is an inventory recommendation.

Compare with parity-testing instead of rounding

When you need to know whether an existing whole number is even, do not round it to test it. The separate documented ISEVEN function tests evenness rather than changing the number: see the official ISEVEN reference. To check whether rounding changed a numeric input without invoking a separate parity test, use =EVEN(B2)=B2 in D2; for B2=2 the expected Boolean is TRUE, but for B2=2.5 it is FALSE. This equality check is not equivalent to testing parity on nonintegral inputs; the interpretation is strictly “unchanged by EVEN.”

A zero and sign audit

=EVEN(0) yields expected 0, unlike ODD(0) which yields 1. Negative inputs remain negative, and a result can differ from the input by nearly 2. If you only need to remove decimals without changing parity, TRUNC has different mathematics: for instance, independently TRUNC(-2.5) is −2 while EVEN(-2.5) is −4. Confirm the actual purpose before selecting one.

Table qualification and copying safely

The reproduction table deliberately places the source and destination inside the same Numbers table, making B2 valid as a relative reference. When the destination is outside ParityRounding, select the source cell through the formula editor; the resulting token may include a table-qualified reference such as ParityRounding::B2. Do not paste an Excel-style sheet reference into Numbers and assume it is equivalent. When copying formulas, check that each row references its own B-column input ([A4]).

This tutorial does not certify the exact Apple Numbers error string, behavior on Boolean/date/duration input, behavior on quoted numeric text, integer overflow limits, or internal floating-point precision. The Apple reference establishes the listed numeric behavior, not every native-app coercion and error state. Errors mentioned here are documented mathematical/domain conditions or troubleshooting hypotheses, not screenshots or runtime observations.

The named function also appears in Microsoft Excel and Google Sheets, with matching basic mathematical intent for the documented cases. This does not establish identical date/duration coercion, localized function names, precise overflow thresholds, display formatting, empty-cell treatment, or native error strings. In particular, moving formulas between Numbers and Excel/Sheets can require changing table/sheet references and locale-specific argument separators. Check any workbook after import, rather than assuming formula parity implies application parity ([X1], [X2]).

• Microsoft Excel — EVEN function
• Google Sheets — EVEN function

• ODD — official function documentation
• ISEVEN — official function documentation

• ODD — continue with a related Apple Numbers calculation.
• CEILING — continue with a related Apple Numbers calculation.
• FLOOR — 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 EVEN, Apache OpenOffice Calc EVEN, Gnumeric EVEN. 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.