How to know if a number, or output of Excel function is odd or even

How to know if a number, or output of Excel function is odd or even

Welcome to your weekly 3 tip Friday update, it’s just a short dose of Excel help before you start the weekend. Each week we’ll cover a tip, a shortcut and a function - making it super easy for you to get better at Excel.

 

If you find this useful or have requests or ideas for future editions, send me a message or comment at the bottom of this post! Now, on with the tips. 

 

A quick win you can learn today -

I never cease to be amazed at how many reports or dashboards have no explanation as to what metrics mean or how they were calculated. It can lead to misinterpretation of reporting, and ultimately can mislead decision making.

Whenever I create a report or dashboard or even a data file which will be used by others, I always try to include a data dictionary or glossary to explain the workings behind the file. Even if it ends up not being used, you can use it as a reference guide to answer frequently asked questions and build procedure notes for your work.

 

A keyboard shortcut I'm adding to my list - 

Ctrl + V is the shortcut to paste, and is one of the best known shortcuts in Excel. I suppose you already know it. But do you still use the right click menu to ‘paste special’? 

Did you know there is a shortcut for this too - Ctrl + Alt + V will show the paste special menu.

 Check some more top tips for working in Excel on Microsoft’s website!

A function I've found super useful this week - 

Another numerical function I often find useful is to know if a number, or output of a function is odd or even. You can do this using the ISODD and ISEVEN.

Each function only has one element - the cell or number you wish to check, and the output will be a TRUE or FALSE value.

You could then combine this with an IF function to create different outcomes based on if the value is odd or even.

 

Hope these were useful, until next time all the best. 

 

- Martyn

Edinburgh, Scotland

June 2018

Get More Exclusive Content

Sent Directly to your inbox with Excel 3 Tip Friday. A weekly dose of Functions shortcuts and tips for getting more out of Excel.

We won't send you spam. Unsubscribe at any time. Powered by ConvertKit