Which function is used to trap and handle errors in Excel...
Which function is used to trap and handle errors in Excel?
IFERROR()
ERROR()
IFNA()
IFTRAP()
IFERRORTHENTRAP()
Correct answer is A
The IFERROR() function is used to trap and handle errors.
Syntax:
=IFERROR (value, value_if_error)
Example:
=IFERROR (A2/C2,"Please enter a value in C2")
How many alignment options are present in Paragraph group in Microsoft Word? ...
In MS Excel, the currently selected cell address is displayed in ____ ...
Which of the following Charts can be created in Excel? ...
You need to ensure all mail from a particular client is stored in that client's folder on your f...
We can request a receipt to show an email has been read by: ...
How can you ensure that a particular meeting on the calendar is only visible to you? ...
Which of the following section does not exist in a slide layout? ...
What is the best way to create another copy of a slide in PowerPoint? ...