Showing posts with label ISEVEN formula in Excel. Show all posts
Showing posts with label ISEVEN formula in Excel. Show all posts

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.