Hide #DIV/0! errors and #N/A errors

Rather than using the IF formula, I suggest using the IFERROR formula. That way you won't need to worry about possible error conditions.

Case of #VALUE! error:

=IFERROR("a" + 1,"")

Case of #DIV/0! error:

=IFERROR(3/0,"")

The second parameter is optional, so you can even simplify the formulas to:

=IFERROR("a" + 1)
=IFERROR(3/0)

Related