+ Reply to Thread
Results 1 to 2 of 2

#DIV/0! Error

  1. #1
    Joohn Calder
    Guest

    #DIV/0! Error

    Hi

    I get an error (#DIV/0!) when I divide one cell by the other and there are
    no entries in the cells.

    How can i get the folrmula to surpress the error (show a blank cell) when
    there are no entries in the cells that the formula refers to?

    Could you please provide an example

    Thanks

    John

  2. #2
    Bob Phillips
    Guest

    Re: #DIV/0! Error

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

    --
    HTH

    Bob Phillips

    "Joohn Calder" <JoohnCalder@discussions.microsoft.com> wrote in message
    news:4A736933-8B5E-4D25-A67F-AADE56803802@microsoft.com...
    > Hi
    >
    > I get an error (#DIV/0!) when I divide one cell by the other and there are
    > no entries in the cells.
    >
    > How can i get the folrmula to surpress the error (show a blank cell) when
    > there are no entries in the cells that the formula refers to?
    >
    > Could you please provide an example
    >
    > Thanks
    >
    > John




+ 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