Home »
MCQs »
Microsoft Excel MCQs
Which function is used to trap and handle #N/A errors?
21. Which function is used to trap and handle #N/A errors?
- IFERROR()
- ERROR()
- IFNA()
- IFERRORNA()
Answer: C) IFNA()
Explanation:
The IFNA() function is used to trap and handle #N/A errors.
Syntax:
=IFNA (value, value_if_na)
Example:
=IFNA(VLOOKUP(A5,xtable,2,0),"Error: Not found")