Introduction: The IFERROR function is a formula-checking tool that detects errors in formulas. For example, when using the VLOOKUP function to search for a student's score by their student ID, an error occurs if the ID does not exist. In such cases, we can use the IFERROR function to provide an appropriate message when an error arises. Its format is as follows: “=IFERROR(formula_to_check, error_message)”. Here’s a detailed tutorial on how to use it.
Steps:
- In the cell where you want to check for language scores, enter “=IFERROR()”.
- Input the first parameter (the formula). Using VLOOKUP as an example, type “VLOOKUP(L2,A1:G6,3,FALSE)”.
- Enter the second parameter—the error message—set it as “No record found; this score is empty.”
- When you input a non-existent student ID, it will display the corresponding error message.