Excel ISEVEN Function

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

The ISEVEN 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 ISODD, ISBLANK, ISNUMBER and ISTEXT.

Syntax

=ISEVEN(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 even or FALSE if it is not.

Download Excel File

 Example of ISEVEN function
error

Comments (No)

Leave a Reply

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