IFERROR(value,value_if_error) returns a value in case of an error; otherwise, returns the result of the formula : IFERROR « Logical functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Logical functions
  3. IFERROR
Input the formula: =IFERROR(A2/B2, "Error in calculation")
Input the formula: =IFERROR
18.4.IFERROR
18.4.1.IFERROR(value,value_if_error) returns a value in case of an error; otherwise, returns the result of the formulaIFERROR(value,value_if_error) returns a value in case of an error; otherwise, returns the result of the formula
18.4.2.Making an Error Behave the Way You Want: output 0Making an Error Behave the Way You Want: output 0