IFERROR function


Returns value_if_error if an expression is an error and the value of the expression itself otherwise.



=IFERROR( value, value_if_error)


required arguments:

value The value, reference, or formula to check for an error.
value_if_error The value to return if an error is found.

Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.