Excel IFERROR Function: How to Use It, with Examples
Turkish: EĞERHATA

If a formula returns an error (#N/A, #DIV/0! and so on), shows a value you choose instead of the error.

IFERROR syntax

=IFERROR(value, value_if_error)

In Turkish Excel: =EĞERHATA(değer; eğer_hataysa_değer)

ArgumentDescription
valueThe formula to check for an error.
value_if_errorThe value to show if there is an error.

IFERROR examples

Sample table:

ABCD
1ProductRegionQuantityPrice
2PenAnkara125
3Notebookİzmir820
4EraserAnkara302
5NotebookAnkara520
6Penİzmir75
=IFERROR(VLOOKUP("Ruler",A2:D6,4,FALSE),"Not found")
Result: Not found

Ruler is not in the table, so it shows "Not found".

=IFERROR(C2/0,0)
Result: 0

Shows 0 instead of a divide-by-zero error.

Results were calculated in real Excel.

Tips for IFERROR

  • It hides every error, including real mistakes in your formula, so use it with care.

Related functions

More formula guides

More tools

About IFERROR Function

If a formula returns an error (#N/A, #DIV/0! and so on), shows a value you choose instead of the error.

Turkish function names were taken directly from Turkish Excel, and the example results on formula pages were calculated in real Excel. Everything runs in your browser; your data is never uploaded.

How to use IFERROR Function

  1. Type the formulaStart typing =IFERROR( in a cell; Excel shows the arguments.
  2. Fill in the argumentsSeparate them with commas (semicolons in Turkish Excel).
  3. Press EnterCheck the result; you can also try it in the tester below.

Frequently asked questions

What is IFERROR in Turkish Excel?

In Turkish Excel, IFERROR is called EĞERHATA. Turkish Excel also separates arguments with semicolons (;) instead of commas.

Which Excel versions have IFERROR?

IFERROR is available in all current Excel versions (2010 and later, Microsoft 365).