Results 1 to 4 of 4

IF function to avoid #DIV/0! error message

Threaded View

  1. #1
    Registered User
    Join Date
    08-02-2009
    Location
    Lancashire, England
    MS-Off Ver
    Excel 2007
    Posts
    84

    IF function to avoid #DIV/0! error message

    Hi

    i am working out a percentage margin and a simple division sum is fine, however when the second value of the sum is missing it throws up the #DIV/0! error message, obviously because it has nothing to divide.

    I am working my sum as simple as F5/E5

    To avoid the message is there a way of using an IF formula to tell it to work out the sum however when cell E5 is empty or 0 then return 0 or nothing. (i.e no error message).

    Your time and help is appreciated.

    Thanks in advance.

    Si
    Last edited by Si902; 08-25-2010 at 02:42 AM.

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