| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF OR formula not working
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) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF OR formula not working
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) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF OR formula not working
Thanks, Dave. I've tried ISNA and get the same results; also get the "too
many arguments" error with NOT(ISNUMBER). CJ "Dave F" wrote: 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) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF OR formula not working
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)) 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) -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF OR formula not working
Thanks, Dave. Formula is working now.
CJ "Dave Peterson" wrote: 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)) 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) -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find value in array | Excel Worksheet Functions | |||
| Is it possible? | Excel Worksheet Functions | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Working Hours (formula & graph) - any elegant solution? | Excel Worksheet Functions | |||
| Array Formula Not Working with Range with Formulas | Excel Discussion (Misc queries) | |||
Linear Mode
