Re: Same formulas, but one returns a #DIV/0! error

Tech-Archive recommends: Fix windows errors by optimizing your registry


"JLatham" <HelpFrom @ Jlathamsite.com.(removethis)> wrote in message
news:886ECD4F-4279-476D-8B15-8DFED491C102@xxxxxxxxxxxxxxxx
In those cases where you're seeing the #DIV/0! error, the cell in column C
probably has an 'invisible character, such as " " (a single space).

Best way to handle this is to specifically look for an error condition:
=IF(ISERR(G23/C23),"",G23/C23)
same for the other formulas as = IF(ISERR(G16/C16),"",G16/C16)
etc. etc.

I beg to disagree, it is better to go to the root of the problem, ISERR
might hide errors that are beneficial to know that they exit whereas the div
error derives from dividing by zero and can be easily fixed by

C23=0


--


Regards,


Peo Sjoblom



.

Relevant Pages

  • Re: Today the weather decided
    ... I beg to differ. ... would disagree with you. ... Did I just say it out loud that the easily confused iAshi is a creation of ...
    (rec.games.computer.ultima.dragons)
  • Re: new comers
    ... I an not f*cken deaf.) ... I beg to disagree. ... You pay absolutely no attention to requests to stop ...
    (comp.lang.java.programmer)
  • Re: Cant change partition table anymore
    ... >Sorry, I disagree. ... >This was true when root was Ken, ... I feel BSD operators are BSD operators because they ... I think most BSD operators expect the power of root to be ...
    (freebsd-current)
  • Re: lu dsik layout
    ... recommend /var in root which I think is somewhat naive to put it ... I don't disagree with the arguments, but I don't think they're overly ... to splitting it out. ...
    (comp.unix.solaris)
  • Re: BTW
    ... Beg to disagree. ... You simply do not pull that kind of stunt with that ...
    (uk.rec.sheds)