How To Use Excel ISODD Function

    how to use excel isodd function

    Quick Intro

    Use Excel ISODD Function to check whether a number is an odd number. If a number is an odd number it will TRUE else FALSE.

    Syntax

    ISODD(value)

    • value Number which you want to test for the odd number.

    More Information on Excel ISODD Function

    • If a number is enclosed in double quotation marks it will treat that number as a text & return FALSE.
    • If the value is not a number it will return a #VALUE error.

    Example

    In the below example, I have used ISODD with IF function to deliver an alert message to the user if a number nested in the cell other than an odd number.

    Examples For Excel ISODD Function

    Sample File

    download sample file to learn more about this tips

    What’s Next?

    To learn more about Excel ISODD Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

    There is also you have ISEVEN function which is highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.