This page isn't translated yet, so its text is in English. Function names and formulas are shown in your Excel language.

Excel function · Logic

SIERREUR(IFERROR)

Shows your own result instead of an error.

What it does

IFERROR calculates a value and, if the result is any error (#DIV/0!, #N/A, #VALUE! and so on), returns the alternative you chose instead.

=SIERREUR(value; value_if_error)

Arguments in square brackets are optional, and … means you can add more of the same. In this Excel language, arguments are separated by ;

value: The formula that might fail.
value_if_error: What to show instead of the error: 0, a message in quotes, or empty text ("").

What should "sales per visitor" show on a day without visitors?

	A	B	C
1	Sales	Visitors	Per visitor
2	300	0	0

The formula in C2:

=SIERREUR(A2/B2;0)

Result: 0

300 divided by 0 is a #DIV/0! error, so IFERROR returns the alternative: 0.

Hiding mistakes you should fix. A typo that gives #NAME? also turns into your fallback, so test the formula before you wrap it.
Using it for lookups where only a missing value is expected. IFNA catches #N/A but still shows other errors.

Excel translates function names, and in some languages the argument separator too. Type the name your Excel shows.