« Best Double Click Tricks - Very Cool ah! | Special Characters Allowed in Excel Formulas and Functions » |
ISERROR vs IFERROR
Welcome, excel_usage, FormulasHi there,
We have discussed IFERROR in the earlier post and now we will discuss on ISERROR and the combination of ISERROR and IFERROR.
Firstly, these both are called error replacing formulas. These two are very important when we discuss on formula errors.
The syntax for ISERROR and IFERROR goes like this:
Syntax: =ISERROR (select cell to find if it is an error)
...
Syntax: =IFERROR (select a cell you want to find an error, replace with this if it is an error)
Note: The above two formulas can be used to replace all the formula errors listed below.
- #NAME?
- #N/A
- #NUM!
- #DIV/0!
- #NULL
- REF!
- ######
- VALUE!
Who are using 2003 version and prior, this trick might look like a best medicine due to absence of IFERROR.
IFERROR can be replaced using combination of IF and ISERROR.
The example for this is:
We have cell A4 = 25/0 which gives #DIV/0!.
So, replacing the below function results same as IFERROR.
=IF(ISERROR(A4)=TRUE,"-",A4)
This means that if cell A4 has an error, then ISERROR gives TRUE. If ISERROR gives TRUE then replace the error with - (hyphen). If ISERROR gives value then it results FALSE so, the cell A4 value will display.
Do you ISERROR and IFERROR?
Do you use this functions while reporting, did you find any challenges, did you achieve better results using these formulas, then please do share your experiences to the blog members.
Learn and Let others learn.
Use this space to share your ideas and questions on this topic in the below comment section.
Thank You.
There are 2 comments on this post but you must be logged in to see the comments. Log in now!
If you have no account yet, you can register now! (It only takes a few seconds)
Recent comments