IsEven IsOdd

How to easily determine if a number is even or is odd in Excel.

• 01:17
• Skill Level: 4
• What's my skill level
  

  All of our videos are listed by user Excel Skill Level.

  To find out your personal skill level, download our quick assessment.

  Once you've completed the test, send it to us and we'll evaluate for you.

  

• 

IsEven IsOdd

If you are required to figure out in a list of numbers, which are even or which are odd, instead of trying to come up with a complex formula to do it have a look at what is available in the Function Wizard. So if we click the Function Wizard, now go to a category called information & you look down, you see there actually is a function called ISEVEN. If you go lower, there’s a function called ISODD. So let’s use the ISEVEN function, say ok. I can point out & say this is my reference number, & you’ll see it tells me in this case, ISEVEN false. When I say ok, I get false & I can now copy this down & I’m told which of these numbers are even & which of these numbers are false. You can then work on this formula to perform some sort of calculation based on whether these numbers are even or odd.