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.
ให้ AI ทำให้Select the target cell
Click on the cell where you want to apply the formula and handle potential errors.
Enter the IFERROR function
Type =IFERROR( and select the cell or formula you want to evaluate.
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)Yes, IFERROR catches all standard Excel errors including #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, and #NULL!.