Formualizer Docs
ReferenceFunctionsInformation Functions

ISODD

ISODD: Returns TRUE if number is odd.

Summary

Returns TRUE when a number is odd.

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

Odd integer
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
true
Boolean coercion
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
true

FAQ

Are booleans valid inputs for ISODD?

Yes. TRUE is treated as 1 and FALSE as 0 before the odd check.

Runtime metadata

Category

Information

Signature

ISODD(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

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

ISNUMBER

ISNUMBER: Returns TRUE when the value is numeric.

ISTEXT

ISTEXT: Returns TRUE when the value is text.

On this page

SummaryRemarksExamplesRelated functionsFAQAre booleans valid inputs for ISODD?Runtime metadata