View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Zeros in text resulting in #div/0! even when using IF function

Hi Annie, I've tried the formulas above and where I have actual data
vs. text, the results returned are 0 vs the appropriate answer. Do you
have an alternate suggestion? Thx.