Using the Excel ISEVEN Function
Summary
The Excel ISEVEN function will return TRUE when a supplied value is even and FALSE when it is odd. If the supplied value isn't numeric, the function returns the #VALUE! error.Syntax
=ISEVEN (value)Syntax Breakdown
ValueRequired. The value to be checked to determine if it is even or odd. The argument is usually supplied as a cell address
Usage Notes
ISEVEN receives a number and returns TRUE if it is even and ODD if it is false.The function is part of Excel's IS functions which return the logical values TRUE or FALSE.
The function will return the #VALUE! error if the supplied value is non-numeric.
