Formualizer Docs
ReferenceFunctionsInformation Functions

ISEVEN

ISEVEN: Returns TRUE if number is even.

Summary

Returns TRUE when a number is even.

Remarks

  • Numeric input is truncated toward zero before parity is checked.
  • Booleans are coerced (TRUE -> 1, FALSE -> 0).
  • Non-numeric text returns #VALUE!.
  • Errors propagate unchanged.

Examples

Even integer
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
true
Decimal truncation before parity
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
false

FAQ

How are decimals handled by ISEVEN?

The number is truncated toward zero before checking even/odd parity.

Runtime metadata

Category

Information

Signature

ISEVEN(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

crates/formualizer-eval/src/builtins/info.rs

ISERROR

ISERROR: Returns TRUE for any error value.

ISFORMULA

ISFORMULA: Returns whether a value originates from a formula.

On this page

SummaryRemarksExamplesRelated functionsFAQHow are decimals handled by ISEVEN?Runtime metadata