View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cjpal cjpal is offline
external usenet poster
 
Posts: 3
Default 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)