+ Reply to Thread
Results 1 to 2 of 2

% difference between two numbers and correct DIV

  1. #1
    Registered User
    Join Date
    12-13-2021
    Location
    London
    MS-Off Ver
    2016
    Posts
    1

    % difference between two numbers and correct DIV

    I'm trying to calculate % difference between two numbers - some of the numbers are 0 so need a formula to correct the DIV to a 0 within the formula

    Tried a few threads online already but cant get it to work!!

    This is to work out how many items have been completed based on how many are due in a table.

    I.e. 2 due & 0 completed so 100%

    Some figures are 0 for due due to data i am using

    Due Completed % Outstanding
    2 0
    1 0
    0 0

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,684

    Re: % difference between two numbers and correct DIV

    =IFERROR ( formula you have , 0)
    that will put a zero instead of an error

    But see the yellow banner and load a sample spreadsheet - so much easier to put a real formula into a working sample
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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. Replies: 31
    Last Post: 07-28-2017, 01:48 PM
  2. [SOLVED] Insert row numbers into column A, reflect correct row numbers when I add or delete rows
    By jcambell in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-31-2015, 02:18 PM
  3. Replies: 8
    Last Post: 06-28-2014, 03:26 PM
  4. [SOLVED] Calculate the correct time difference
    By mukeshbaviskar in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-02-2013, 02:35 AM
  5. Replies: 12
    Last Post: 04-24-2011, 05:45 PM
  6. Can't get the difference in time correct
    By Lewis Koh in forum Excel General
    Replies: 5
    Last Post: 04-20-2010, 08:39 AM
  7. [SOLVED] show difference between weights with correct pos and neg values
    By Sharon Durow in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-30-2006, 01:20 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