ExcelFlux

ISODD function

TRUE if the number is odd.

Information

Where can you use it?

Workbook and data quality owners. Use functions that inspect cell type, errors or the calculation environment when validating a report.

Scenario in the workbook

Identify odd batch numbers. The result depends on parity, not magnitude.

A worked example from the workbook

RowA
6Input
742
843
9-3
Record 1
=ISODD(A7)

Expected resultFALSE

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=ISODD(42)
Turkish Excel · tr-TR
=TEKMİ(42)

Expected result

FALSE

Worked examples

Identify odd batch numbers. The result depends on parity, not magnitude.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A
6 Input
7 42
8 43
9 -3
Case Formula Expected result
Record 1 =ISODD(A7) FALSE
Record 2 =ISODD(A8) TRUE
Record 3 =ISODD(A9) TRUE
Microsoft Excel reference