This function allows you to test a expression and returns TRUE if your given expression results in an error (#DIV/0, #N/A, #NAME, #NULL!, #NUM!, #REF!, or #VALUE!) and FALSE otherwise.
ISERROR(Value)
In this example we test a few values some of which are errors. Only the errors result in TRUE.
=ISERROR(A2)
Subscribe for awesome Microsoft Excel videos 😃
I’m John, and my goal is to help you Excel!
You’ll find a ton of awesome tips, tricks, tutorials, and templates here to help you save time and effort in your work.
This function allows you to test an expression and returns TRUE if your given...
This function will test if a value is numerical and return TRUE if it is a...
This function will test if a value is text and return TRUE if it is text and...
Follow us to stay up to date with the latest in Microsoft Excel!
Subscribe for awesome Microsoft Excel videos 😃
0 Comments