ISERROR function

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.

 

Syntax

 

ISERROR(Value)

 

  • Value (required) – This is the value that is checked for an error.

 

Example

 
In this example we test a few values some of which are errors. Only the errors result in TRUE.
 

=ISERROR(A2)

ISERROR

About the Author

John MacDougall

John MacDougall

John is a Microsoft MVP and qualified actuary with over 15 years of experience. He has worked in a variety of industries, including insurance, ad tech, and most recently Power Platform consulting. He is a keen problem solver and has a passion for using technology to make businesses more efficient.

Related Posts

ISERR function

This function allows you to test an expression and returns TRUE if your given...

read more

Comments

0 Comments

Get the Latest Microsoft Excel Tips

Follow Us

Follow us to stay up to date with the latest in Microsoft Excel!

Subscribe for awesome Microsoft Excel videos 😃