+ Reply to Thread
Results 1 to 4 of 4

#div/0

  1. #1
    Registered User
    Join Date
    03-31-2011
    Location
    Stavanger, Norway
    MS-Off Ver
    Excel 2007
    Posts
    19

    #div/0

    Hi!

    I need to get rid of the #DIV/0 error. I want it to be 0 instead.
    In column D I have the formula: =IF((C1=0);0;(C1/(A1+B1))). I got rid of the #DIV in cell D2, but not in the D1. Could someone help me?

    A B C D
    0 0 40 509 #DIV/0!
    233 332 103 362 0 0 %


    Thanks in advance!
    Last edited by nitrone; 10-28-2011 at 06:48 AM.

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: #div/0

    Perhaps
    Please Login or Register  to view this content.
    (If C1=0 it will return 0)

  3. #3
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: #div/0

    A1 and B1 are 0 in row 1, so C1/(A1+B1) is the same as C1/0.

    You need a formula that checks if A1+B1 is 0.

    Can you work it out?

  4. #4
    Registered User
    Join Date
    03-31-2011
    Location
    Stavanger, Norway
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: #div/0

    Thanks!

    I got it now! :D

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1