G Guest Oct 20, 2006 #1 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)
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)
G Guest Oct 20, 2006 #2 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
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
G Guest Oct 20, 2006 #3 Thanks, Dave. I've tried ISNA and get the same results; also get the "too many arguments" error with NOT(ISNUMBER). CJ
Thanks, Dave. I've tried ISNA and get the same results; also get the "too many arguments" error with NOT(ISNUMBER). CJ
D Dave Peterson Oct 20, 2006 #4 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))
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))
G Guest Oct 23, 2006 #5 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...
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...
