Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    388
    Thanks
    3
    Thanked 0 Times in 0 Posts

    GET RID OF #DIV/0 (XP & 2003)

    I HAVE SOME FORMULAS WHICH RETURN A #DIV/0. IS THERE ANY WAY OF MAKING THE RESULT 0 OR A SPACE.

    THANKS

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: GET RID OF #DIV/0 (XP & 2003)

    If there are no other upstream (source cell) errors of any type, and where the names I use are the corresponding source cells, the simplest is:

    =IF(denominator,numerator/denominator,0)

    However, if there's a possibility for any Excel errors in the source cells, this is safer:

    =IF(ISNUMBER(numerator/denominator),numerator/denominator,0)
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Star Lounger
    Join Date
    Feb 2003
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: GET RID OF #DIV/0 (XP & 2003)

    John,

    Could the N function be used in place of ISNUMBER?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: GET RID OF #DIV/0 (XP & 2003)

    I don't think so, N will result in an error if the division is invalid, and hence the formula as a whole too. You can reverse the logic and use ISERROR:

    =IF(ISERROR(numerator/denominator),0,numerator/denominator)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •