Which function is used to trap and handle #N/A errors in ...
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")
Which of the following is not a type of Microsoft access database object? ...
Which of the following is database management system software? ...
Which of the cell pointer indicates that you can fill series? ...
Microsoft Access is a ____________ ? ...
How can you tell the email that you have read from the email that you have not read? ...
How can you remove a relationship defined between two tables in MS Access? ...
The intersection of a column and a row in a worksheet is called ____ ...
Which tool would you use to view the calendars of your entire team at the same time? ...