What is IFERROR function in Excel?
The IFERROR function is one of the Logical functions of Excel.
It returns value_if_error if the expression is an error and the value of the expression itself otherwise.
We can find this in the Logical functions of the insert the function Tab.
How to use IFERROR function in excel
1. Click on empty cell (like F5 )
2. Click on the fx icon (or press shift+F3)
3. In the insert function tab you will see all functions
4. Select Logical category
5. Select IFERROR function
6. Then select ok
7. in Value section we can enter any value or expression or reference.
8. in Value_if_error section we can enter What to display if the condition is Wrong.
9. You will see the result in formula result section
Examples of IFERROR function in excel
10. Enter values in cells as shown below:
11. Enter in Value section —-> A3/A2
12. Enter in Value_if_error section —-> “wrong calculation”
13. the result is “wrong calculation” because 1/0=infinite.
What is the purpose of IFERROR function?
What is the Return value of IFERROR function?
How many arguments does IFERROR function have?
This function has just 1 Argument.
The argument of ABS function is number.
The argument of ABS function is required and not optional.
Which version of excel supports IFERROR function?
This function is available for all excel versions (2003-2019)
Errors in IFERROR function
IFERROR related functions :
- ISERROR Function
- IFNA Function
