the formula below is working unless results in an error (esp. #N/A)... IF(OR(ISERR((G39/D39)*H39),(G39/D39)*H39=0),"-",(G39/D39)*H39)