Handle error formulae in excel

Most of the time when we perform any calculation using formulaes and they return #Value or #N/A which we don't want to return instead we need to display blank or 0 values. We can do this by using following formulae.

To display blank when the formulae returns error "=iferror([original formula which you want to perform],"") "

To display 0 when the formulae returns error "=iferror([original formula which you want to perform],"0") "

Example 1: =iferror(Sum(A1:A14),"")

Example 2: =iferror(Sum(A1:A14),"0")