ISERR doesn't check for #N/A. ISNA checks for #N/A

If you're trying to check for all errors, try something like

IF(OR(NOT(ISNUMBER((G39/D39)*H39))),(G39/D39)*H39=0),"-",(G39/D39)*H39)

Dave

--
Brevity is the soul of wit.


"cjpal" wrote:

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)