IF OR formula not working

  • Thread starter Thread starter Guest
  • Start date Start date
G

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)
 
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
 
Thanks, Dave. I've tried ISNA and get the same results; also get the "too
many arguments" error with NOT(ISNUMBER).

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))
 
Thanks, Dave. Formula is working now.

CJ

Dave Peterson said:
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))
Click to expand...
 
Back
Top