How to use the ISNUMBER excel function to differentiate between cells that are a valid excel number and others which are not.
- 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.
- - 1:43
- - Skill Level: 3
- - What's my skill level
ISNUMBER Excel function
The ISNUMBER Excel function allows you to check whether a cell contains a number or not. So for example if we want to use the ISNUMBER function, we activate the function wizard, we find it, say ok. And you’ll see you only have to just point at the cell where you’re trying to check, & we say ok. You’ll see in this case it tells us that that is a number so it’s true. And the benefit is if I copy this down, you’ll see it looks & it says true. If there’s an error message, for example a divide by zero message, it will then identify that there’s a false.
So you can build some sort of a check to say, if there’s an error, tell me something or do something. Typical example would be equals if that equals true, then we just want to show whatever numbers there. If it equals false, then for example we put a zero. And now when we copy & paste that down, you’ll see it automatically looks, & if it’s an error it’ll then put a zero otherwise it’ll actually bring the number through , which just actually helps to avoid errors that creep into models & filter through all the calculations.