Excel IFERROR formula

Avoid errors such as #N/A, #VALUE! or #DIV/0!.

=SE.ERRORE(A2/B2;"")

=IFERROR(A2/B2,"")

Example

If B2 is zero, the cell stays blank instead of showing #DIV/0!.

Common error

Do not use it to hide important errors without checking the cause.

How it works

IFERROR is useful to clean sheets with incomplete calculations.

You can replace empty quotes with a text.

Can I show zero instead of blank?

Yes, use ,0.

Does it hide all errors?

It catches many common errors.