Transcript(click to view)
Welcome to Excel Intuition’s Isnumber Function Example 1 video. Suzanne here. If you haven’t already done so, I recommend you download the companion workbook that goes along with this video so you can try this on your own and explore further. You can find the link to the companion workbook in the YouTube video entry.
I’m going to click to the Information Function Examples worksheet. We have a table here with Function Names, Definitions, empty cells for Value entries, and cells in which to enter the actual functions. We’re going to use this third row down for the Isnumber Function, and we’re testing whether the contents of the cell to the left of this function, in G8, has a number as a value.
Right now this cell is empty, there’s no value in it, and we get the result that Isnumber is FALSE. If I enter
the word “text”
I still get a FALSE value, but if I change that to a numerical value such as 45, now I get a value of TRUE, and you could experiment further and see how this works for you. Thank you very much.