Excel ISODD Function

The ‘ISODD’ formula in Excel is used to ascertain whether or not a value is odd. It returns TRUE if the input number is odd, or FALSE if it is not. Where the input value is not numerical, a #VALUE error is returned.

The ISODD function is part of a larger group of IS functions that all return logical values (i.e. TRUE or FALSE). The other IS functions are ISEVEN, ISBLANK, ISNUMBER and ISTEXT.

Syntax

=ISODD(number)

Arguments

Number – input number to check. Typically, you would reference a cell address when using this formula.

Function category

Information

Returns

Returns a logical value i.e. TRUE if the input number if odd or FALSE if it is not.

Download Excel File

 Example of ISODD function
error

Comments (No)

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.