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")
