How to easily determine if a number is even or is odd in Excel.
- For updated video clips in structured Excel courses with practical example files, have a look at our MS Excel online training courses . You can even try the Free MS Excel tips and tricks course.
- To see if this video matches your skill level (see the suggested skill score below) do our free MS Excel skills assessment.
- If you are based in South Africa look at the live courses we offer in Johannesburg and Cape Town.
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.