Home »
MCQs »
Microsoft Excel MCQs
Which function is used to trap and handle errors?
20. Which function is used to trap and handle errors?
- IFERROR()
- ERROR()
- IFNA()
- IFTRAP()
Answer: A) IFERROR()
Explanation:
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")