How to use Excel ISEVEN Function

    how to use excel iseven function

    Quick Intro

    Excel ISEVEN Function will evaluate a value and return TRUE if a value is an even number and else it will return FALSE. In simple words, you can check that a value is an even number or not.

    Syntax

    ISEVEN(number)

    • number A value which you wants to evaluate.

    More Information on Excel ISEVEN Function

    • You can also insert a number into function directly by using double quotes or even without it.
    • If you specify a non-numeric value it will return the #VALUE! error value.

    Examples

    Here I have used different arguments for this function.

    Examples For Excel ISEVEN Function

    1. It will return TRUE if given number is even.
    2. It will evaluate negative values in the same way.
    3. It will treat 0 as an even number.
    4. If you specify a number with decimal points it will ignore decimals & evaluate the integer. In this example, it has truncate .5 & evaluated 2.
    5. As excel store dates as serial numbers, it will evaluate them in the same manner.

    Sample File

    download sample file to learn more about this tips

    What’s Next?

    To learn more about Excel ISEVEN 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 ISLOGICAL function which is highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.