Which function is used to trap and handle #N/A errors in Excel?
IFERROR()
ERROR()
IFNA()
IFERRORNA()
Correct answer is C
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")