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")
Comments can be added to cells using ________ ...
How many worksheets can a workbook have? ...
Using Word, you can insert text and create new documents by following the steps listed below: ...
The slide that is used to introduce a topic and set the tone for the presentation is called the ...
What is the correct value of the function? =ROUND (1.2345,2) ...
You need to arrange a meeting for all employees in a particular department - do you: ...
What is the default filename of a PowerPoint file? ...
Steps to change the text case in a document are – You can change any text by selecting i...