Using the Excel ISEVEN Function
SummaryThe 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.
Required. The value to be checked to determine if it is even or odd. The argument is usually supplied as a cell address
Usage NotesISEVEN 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.