+ Reply to Thread
Results 1 to 4 of 4

removing #DIV/0!

  1. #1
    Forum Contributor
    Join Date
    10-04-2007
    Posts
    118

    removing #DIV/0!

    I have the following forumla....

    =SUM(B11+E11)/F11

    in those three cells there is a value of 0

    the following message appears in the formula cell - #DIV/0!

    is there a way to change my formula so it doesn't display this message and just return 0

    thanks in advance
    Last edited by akhlaq768; 10-09-2008 at 05:58 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    06-30-2005
    Location
    Verwood, Dorset, England
    MS-Off Ver
    Excel 2000
    Posts
    479
    Try

    =IF(F11=0,0,SUM(B11+E11)/F11) which returns 0

    or

    =IF(F11=0,"",SUM(B11+E11)/F11) which returns a blank
    Paul

  3. #3
    Forum Contributor
    Join Date
    07-23-2006
    Posts
    185
    Also
    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    10-04-2007
    Posts
    118
    thanks guys,

    you perfect :-)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Removing Div#/0 from with Function check
    By Hawkeye in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-29-2008, 08:42 AM
  2. #DIV/0! issues
    By peakymatt in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-11-2008, 08:15 PM
  3. #DIV/0 Error, when there is NO "0" possible!
    By Walker in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-07-2007, 09:30 AM
  4. removing the #DIV/0! error
    By quickbrwnfox in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 06-14-2007, 12:58 AM
  5. ignore #DIV/0!
    By blackstar in forum Excel General
    Replies: 3
    Last Post: 01-09-2007, 12:25 PM

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