EVEN Function (LibreOffice Calc)

• Rounds up to the nearest even integer
• Always rounds away from zero
• Works with positive and negative numbers
• Useful for batching, grouping, and integer normalization

EVEN(number)

Arguments

• number:
  Any real number to be rounded to the next even integer.

Positive numbers

=EVEN(3.2)
→ 4

=EVEN(4)
→ 4

=EVEN(4.1)
→ 6

Negative numbers (round away from zero)

=EVEN(-1.2)
→ -2

=EVEN(-4)
→ -4

=EVEN(-4.1)
→ -6

Zero

=EVEN(0)
→ 0

Normalize quantities to even packaging units

=EVEN(A1)

Force even row indexing

=EVEN(ROW())

Round time intervals to even minutes

=EVEN(MINUTE(A1))

Combine with ABS for symmetric rounding

=SIGN(A1) * EVEN(ABS(A1))

Use in engineering tolerances

=EVEN(A1 / tolerance) * tolerance

Ensure even batch sizes

=EVEN(quantity / 2) * 2

EVEN returns an integer

Behavior details

• Always rounds away from zero
• If the number is already even → returned unchanged
• Works with decimals, integers, and negative values
• Equivalent to:
  • Positive: round up to next even
  • Negative: round down to next even (more negative)

Invalid input → Err:502

• Use EVEN when you need predictable, away‑from‑zero rounding
• Use ODD for the complementary odd‑integer rounding
• Combine with ABS and SIGN for custom rounding logic
• Use in batching, packaging, and engineering normalization
• Document rounding assumptions in models

• ODD — round to nearest odd integer
• INT / TRUNC — toward zero
• ROUND / ROUNDUP / ROUNDDOWN — general rounding
• CEILING / FLOOR — directional rounding
• ABS / SIGN — custom rounding logic

By mastering EVEN, you can build clean, predictable integer‑rounding workflows in LibreOffice Calc.