Results 1 to 4 of 4

removing #DIV/0!

Threaded View

  1. 10-08-2008, 12:02 PM #1
    akhlaq768
    akhlaq768 is offline
    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.
    Reply With QuoteRegister To Reply
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1