+4 votes
75 views
Excel: Use IFERROR function correctly

in Office by (550k points)
reopened | 75 views

1 Answer

+5 votes
Best answer

How is the IFERROR function structured in Excel?
Example of an IFERROR formula

Would you like to know how to use the IFERROR function in Excel? We'll show you..

image image

With an Excel table with a lot of data, it quickly becomes confusing. And confusion can just as quickly lead to errors. In order to be able to correct errors quickly, there is the IFERROR function in Excel. In the following article, we will explain how you can use this optimally.

Here you will find more Excel tips on the subject of target search, data verification and actual formulas.

How is the IFERROR function structured in Excel?

The IFERROR function in Excel is used to check your data in the table. A value to be checked is specified for this purpose. If one of the following errors occurs, the function spits out one of the following error messages: # N / a, #Value !, #ref !, # DIV / 0 !, #Num !, #Name? or #NULL !. The message takes place via a notification text that you can define yourself. If there is no error, you will be shown the result of the corresponding data instead..

The formula for the function is structured as follows:

=WENNFEHLER(Wert;Wert_falls_Fehler)

So the formula for the IFERROR function has two arguments:

Value : Here it must be specified what should be checked for an error. For example, you can specify cells that contain an invoice or represent the result of an invoice. You can also insert an invoice (with cell references) as a value yourself.

Value_falls_Error : Here you enter what should be displayed if an error is found. This can be, for example, "error in the calculation" or simply "error". The function then shows you this printout when an error has been detected. Please note : You can enter numbers without quotation marks in "Wert_falls_Fehler". However, you must put quotation marks in the formula for words or combinations of letters. In the following we show you two examples:

Example of an IFERROR formula

example 1

=WENNFEHLER(A1/B1;"Fehler")

image
Here cell A1 with the value 2 has been divided by cell B1 with the value 1. The result is 2 and is therefore not incorrect. So the correct result is shown in cell C1.

Example 2

=WENNFEHLER(A2/B2;"Fehler")

image
In this example, the value of the A column is again divided by the value of the B column. However, this time A2 with value 2 is to be divided by B2 with value 0. It cannot be divided by 0, which is why the set message "Error" is output in cell C2.

by (3.5m points)

Related questions

+3 votes
1 answer
asked Nov 16, 2021 in Office by backtothefuture (550k points) | 75 views
+4 votes
1 answer
asked Nov 14, 2021 in Office by backtothefuture (550k points) | 71 views
+5 votes
1 answer
+3 votes
1 answer
asked Mar 31, 2023 in Office by backtothefuture (550k points) | 57 views
Sponsored articles cost $40 per post. You can contact us via Feedback
10,627 questions
10,759 answers
510 comments
3 users