ISEVEN Function in Excel

What Does It Do?

This function tests a number to determine whether it is even or not. An even number is shown as TRUE an odd number is shown as FALSE. 

• Note that decimal fractions are ignored.
• Note that dates can be even or odd.
• Note that text entries result in the #VALUE! error.  

Refer the below example for your better understanding:

Syntax:

    =ISEVEN(CellToTest)

Formatting:

No special formatting is required.