Excel kılavuzu

How to use IFERROR in Excel

The IFERROR function allows you to clean up your spreadsheets by replacing messy error codes like #N/A, #VALUE!, or #DIV/0! with a user-friendly message or a specific value.

Bunun yerine yapay zekâ ile yap

Adım adım

1
Select the target cell
Click on the cell where you want to apply the formula and handle potential errors.
2
Enter the IFERROR function
Type =IFERROR( and select the cell or formula you want to evaluate.
3
Define the fallback value
Add a comma followed by the value or text you want to display if an error occurs, then close the parenthesis.

=IFERROR(value, value_if_error)

İpuçları

Use double quotes around text strings, for example: "Data Not Found".
You can use an empty string "" to leave the cell blank if an error occurs.

SSS

Does IFERROR hide all types of errors?

Yes, IFERROR catches all standard Excel errors including #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, and #NULL!.

İlgili kılavuzlar

Excel'de IF İşlevi Nasıl Kullanılır