Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up

What does the IFERROR function do?

  1. A Returns a specified value when a formula evaluates to an error
  2. B Prevents all errors in the workbook
  3. C Highlights errors in red
  4. D Logs errors to a separate sheet
Answer

Returns a specified value when a formula evaluates to an error

Use it deliberately, since it hides genuine problems as well as expected ones such as a legitimate no-match result.

All Microsoft excel MCQs

Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up as