IFERROR vs IFNA Function in Excel (Video in Khmer)

Hello everyone! Today I show you how to use IFERROR and IFNA formula in Excel step by step with simple examples and video speak Khmer.

You ever get error message like #N/A, #DIV/0!, #VALUE!, or #REF! in your Excel spreadsheet? Usually this happen when you use lookup formulas like VLOOKUP, MATCH, or when division by zero happen. These errors look ugly and mess up your report calculations! Excel have formulas called IFERROR and IFNA to catch these errors and replace them with nice clean text or number.

Let's look at how to use both function below.

1. How to Use IFERROR Formula in Excel

IFERROR function help you check if a formula result is ANY kind of error (like #N/A, #DIV/0!, #VALUE!, #REF!, #NAME?). If an error happen, Excel show custom value you choose (like "Not Found" or 0).

Formula Syntax:

=IFERROR(value, value_if_error)

Example:

Using VLOOKUP to search student name by ID. If student ID not in table, VLOOKUP gives #N/A error. Wrap it with IFERROR:

=IFERROR(VLOOKUP(A2, Data!A:B, 2, FALSE), "Not Found")

• If ID found ➔ Returns Student Name (e.g., Sophea)
• If ID not found ➔ Returns Not Found

Watch videos below for step by step guide in Khmer:

2. How to Use IFNA Formula in Excel

IFNA function is specialized version of IFERROR. It ONLY catches #N/A error (Value Not Available), which is very common with VLOOKUP, HLOOKUP, MATCH, or XLOOKUP. If formula gives another error like #DIV/0!, IFNA will NOT hide it!

Formula Syntax:

=IFNA(value, value_if_na)

Example:

=IFNA(VLOOKUP(A2, Data!A:B, 2, FALSE), "Name Not Available")

• If VLOOKUP returns #N/A ➔ Returns Name Not Available
• If formula has math error #DIV/0! ➔ Shows #DIV/0! so you can debug real calculation problem!

💡 Quick Tip: Be careful when using IFERROR everywhere! IFERROR hides ALL errors including real formula mistakes (like spelling formula name wrong #NAME? or dividing by zero #DIV/0!). When doing lookup formulas (like VLOOKUP or MATCH), it is safer to use IFNA because it only hides #N/A missing data errors and leaves real mistakes visible so you can fix them!

📚 Useful Resources

• XLOOKUP vs INDEX+MATCH Function in Excel (Video in Khmer)
• If vs Ifs Function in Excel (Video in Khmer)
• Top 15 Basic Excel Formulas Every Beginner Should Know
• How to Allow Input Number and Text Only in Excel with Data Validation
• Free Download PDF - 50 Popular Excel Formulas Cheatsheet (Khmer Language)