+ Reply to Thread
Results 1 to 3 of 3

removing the #DIV/0! error

  1. #1
    Registered User
    Join Date
    05-21-2007
    Posts
    24

    removing the #DIV/0! error

    can someone pls tell me how to stop this error from appearing everytime on my cells... to fully understand here's my scenario:

    cells A and B are input cells, and cell C is my formula cell, when cells A and B are empty the error #DIV/0! keeps appearing, somebody please help!

    THANKS

  2. #2
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    Are you dividing one cell by the other, ie A1/B1?

    If so, set up a conditional, like this:

    =IF(B1,A1/B1,"")

    If you're dividing B1/A1, it would look like this:

    =IF(A1,B1/A1,"")

    Let me know if that works

  3. #3
    Forum Contributor
    Join Date
    11-23-2005
    Location
    Perth, Australia
    Posts
    218

    removing the #DIV/0! error

    or this:

    =IF(ISERROR(A1/B1),"",A1/B1)

    Put what you want to appear in the cell if it is an error between the ""
    Last edited by Steel Monkey; 06-14-2007 at 01:12 AM.

+ 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