+ Reply to Thread
Results 1 to 4 of 4

IF function to avoid #DIV/0! error message

  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.

  2. #2
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: IF function to avoid #DIV/0! error message

    =if(e5=0,0,f5/e5)

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

    Re: IF function to avoid #DIV/0! error message

    Works a treat.

    Thanks Andrew R

  4. #4
    Registered User
    Join Date
    04-14-2010
    Location
    NZ
    MS-Off Ver
    2007,2010
    Posts
    86

    Re: IF function to avoid #DIV/0! error message

    or
    =IF(AND(E5<>"",E5<>0),F5/E5,"")

+ 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