LoveByPDF logo

LoveByPDF
EN

Conditions · IFERROR

IFERROR in Excel - hide #DIV/0!, #N/A and other errors

IFERROR returns your own value (0, a blank, a message) instead of an error.

=IFERROR(value, value_if_error)
Write it for my sheet

Examples

Type this in the Formula StudioFormula
“D2/E2 if error 0”=IFERROR(D2/E2,0)
“D2/E2 and show blank if error”=IFERROR(D2/E2,"")
“iferror D2/E2 then 0”=IFERROR(D2/E2,0)
“sum of D2:D10 but hide errors”=IFERROR(SUM(D2:D10),"")

People also search for

  • iferror formula in excel
  • iferror vlookup
  • how to remove #div/0 in excel
  • iferror with vlookup in excel
  • hide #n/a in excel
  • iferror formula in excel with example
  • ifna formula in excel
  • replace error with 0 in excel
  • iferror blank instead of 0
  • iferror in excel in hindi

FAQ

What is the difference between IFERROR and IFNA?

IFERROR catches every error (#DIV/0!, #N/A, #VALUE!, #REF! and more). IFNA catches only #N/A, so real mistakes in a lookup still show.

How do I show a blank instead of an error?

Use empty quotes as the second argument: =IFERROR(D2/E2,""). Note the cell then holds text "", not a true blank.

Can LoveByPDF write this formula for me?

Yes. Open your Excel file in the Excel Agent's Formula Studio, click a cell and type what you need - e.g. "D2/E2 if error 0" - you get the formula, a preview on your sheet and an explanation, then insert it.

Related formulas