How to easily determine if a number is even or is odd in Excel.
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.
Advanced Excel and Financial Modeling Training in July and August 2013 Over the next 2 months we will be running a number of Excel related courses. In particular we will be covering Advanced Excel and Financial Modeling training. The dates … Continue reading
Sheet Navigation in Excel 2013 Sheet navigation in Excel 2013 is slightly changed and on initial viewing you may wonder where some of the buttons have gone. In particular, you might want to know how you get to the very … Continue reading
Just a quick note to say your blog is brilliant. Full of useful bits of info. After your courses, I am by far the best modeller in our office, and we regularly get comments from our business partners on the quality of our models. Thanks for all the help,– Mike