0

In Excel, your formulas come out in error, but you don‘t want to display the errors without using an extended formula?

When formulas come out in error, it is possible not to display error messages or a particular message.

IFERROR

The IFERROR function works as follows:

=IFERROR(value,value_if_error)

The errors are:

  • #N/A
  • #VALUE!
  • #REF!
  • #DIV/0!
  • #NUM!
  • #NAME?
  • #NULL!

Don‘t show errors

Thus, the use will be as follows:

=IFERROR([Your formula],””)

The criteria ““ refers to empty. If you want to display a message, you must enter the message in quotation marks (e.g. “KO“).

0