IFERROR function in Excel

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 )

Click on empty cell excel

2. Click on the fx icon (or press shift+F3)

fx icon excel

3. In the insert function tab you will see all functions

insert function tab excel

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

How to use IFERROR function in excel

Examples of IFERROR function in excel

10. Enter values in cells as shown below:

Examples of IFERROR function in excel

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.

IFERROR function in excel

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 :

Leave a Reply

Your email address will not be published. Required fields are marked *