ISERROR Function

Originally published at: ISERROR Function - Excelbuddy.com

The ISERROR function in Excel returns TRUE for any error type excel generates. This list of errors includes: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL! It is common to use the ISERROR function nested with other functions. In the example below, we will demonstrate using this function with the IF Function to test for errors…