Thursday, May 5, 2016

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:

ISEVEN Function Example Image

Syntax:

    =ISEVEN(CellToTest)

Formatting:

No special formatting is required.