We can use ISERROR or IFERROR function to tackle and handle errors of database. Mostly Errors are the result of formula. Display blank or give proper message for error using IFERROR or ISERROR function
Download file: ISERROR and IFERROR
How to use ISERROR function in excel?
ISERROR function checks if the value in cell is an error or not. If it is an Error, returns TRUE otherwise FALSE.
=ISERROR( value )
Value: Provided value or result from a formula or a cell reference
Let us see an example to understand in detail.
This example checks the value in cell A1 and A2 whether there is any error or not.
How to use IFERROR function in excel?
IFERROR function checks whether specified cell value is an Error. In case of error it returns user specified value. The following error types are evaluated: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.
IFERROR function has been introduced in Excel 2007 and later.
= IFERROR( value, value_if_error )
Where value: The value that needs to be tested.
Value_if_error: The value that needs to be returned if value argument returns an error.
For example, in this case B1 is 0, so A1/B1 will show an error. IFERROR function will display the user specified value "invalid" in the result cell
=IFERROR(A1/B1, "invalid ")
TIP: Display blank ("") if error evaluates to an error. That will be useful to manage your data
IFERROR function is really useful when you don't want to show the cells with an error. Display blank ("") in case of error. That way you can easily tackle with the errors of your workbook and keep your workbook neat and clean.
How to handle error using ISERROR, if you are using Excel 2003 or earlier version?
Use ISERROR with IF Function which works as similarly as IFERROR.
For example, we can use ISERROR with IF function, So if ISERROR results in true( In this case, A1/B1), provide the message you want to display in [Value_if_True] step.(i.e."invalid"), and In [Value_if_False] step,( which means A1/B1 result is some value), you can write the same formula again(i.e. A1/B1)
IF (ISERROR (A1/B1,"Invalid",A1/B1) Works same as,= IFERROR(A1/B1, "invalid ")
If you find this useful, you can stay connected with us on facebook to get more amazing tips and tricks of Microsoft excel.
3,642 total views, 4 views today