ISODD function in EXCEL

Use

Checks whether a cell’s data has odd or even numbers.

Description

After Appling ISODD function, it returns TRUE if the numeric value is odd otherwise FALSE for even one.

Syntax

=ISODD(number)

(number) – It is the required value to test.

Example

Formulas:

Results:

If the number (tested cell value) is not an integer, it is truncated.

ISODD function common error

The function returns with #VALUE!, when the tested value/ number is nonnumeric.

(To know how to change formats to get numeric values, click here)

Copyright © 2016 - 2018 Explainry.com | All Rights Reserved