When we are writing formulae we are often interested in ensuring that the result does not end in an error. But sometimes we also want to remove any errors being displayed in the formula result.
We can do this by combining the IF and ISERROR functions.
For example, the following formula will result in a blank if cell B1 has a value of zero in it:
=IF(ISERROR(A1/B1),"",A1/B1)
An alternative to the ISERROR function is the ISERR function.
Similar to the ISERROR function, the ISERR function will remove most error messages (such as #VALUE!, #REF!, #NUM!, #NAME?) but it will still display the #N/A error message.
