IF OR formula not working

[Guest]

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)

 

[Guest]

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

 

[Guest]

Thanks, Dave. I've tried ISNA and get the same results; also get the "too
many arguments" error with NOT(ISNUMBER).

CJ

 

[Dave Peterson]

You could try =iserror():

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

If (g39/d39)*h39 is an error, then this portion:
(G39/D39)*H39=0
will be an error and cause your formula to return an error.

Maybe rewriting the formula would help:
=IF(ISERROR((G39/D39)*H39),"-",IF((G39/D39)*H39=0,"-",(G39/D39)*H39))

or since dividing by D39 doesn't help in the second if:
=IF(ISERROR((G39/D39)*H39),"-",IF(G39*H39=0,"-",(G39/D39)*H39))

 

[Guest]

Thanks, Dave. Formula is working now.

CJ

You could try =iserror():

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

If (g39/d39)*h39 is an error, then this portion:
(G39/D39)*H39=0
will be an error and cause your formula to return an error.

Maybe rewriting the formula would help:
=IF(ISERROR((G39/D39)*H39),"-",IF((G39/D39)*H39=0,"-",(G39/D39)*H39))

or since dividing by D39 doesn't help in the second if:
=IF(ISERROR((G39/D39)*H39),"-",IF(G39*H39=0,"-",(G39/D39)*H39))