+ Reply to Thread
Results 1 to 5 of 5

Percentage of differance

  1. #1
    Registered User
    Join Date
    03-31-2015
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    17

    Percentage of differance

    Hi,

    I have Faults repaired on time in A1 and faults repaired late in A2.
    If i wanted to work out the percentage of faults repaired on time what do i need to do?
    I have so far done =(A1+A2)/A2. but this is coming out incorrect. As well as giving the wrong answer, the formulae also falls over when A2 is 0.

    TIA

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Percentage of differance

    If you want percentage of faults repaired on time for the total no faults.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    03-27-2015
    Location
    India
    MS-Off Ver
    2013
    Posts
    18

    Re: Percentage of differance

    Hello,

    Percentage of faults repaired on time = Total number of faults repaired on time / Total number of faults repaired
    =A1/(A1+A2)

    Warm Regards,
    Pritish

  4. #4
    Registered User
    Join Date
    03-27-2015
    Location
    India
    MS-Off Ver
    2013
    Posts
    18

    Re: Percentage of differance

    Hello,

    Percentage of faults repaired on time = Total number of faults repaired on time / Total number of faults repaired
    =A1/(A1+A2)

    Warm Regards,
    Pritish

  5. #5
    Registered User
    Join Date
    03-31-2015
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    17

    Re: Percentage of differance

    Thank you.

+ 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. Differance Networkdays vs Workdays
    By Trumpy in forum Excel General
    Replies: 2
    Last Post: 09-18-2015, 06:50 AM
  2. Computing the differance between two Northing and Eastings
    By RRien07 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-12-2015, 12:50 PM
  3. Calculate Time differance in label
    By amolryeolekar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-03-2012, 01:08 PM
  4. Date Differance collection
    By plopleuk in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 07-04-2009, 01:39 AM
  5. Tracking Time Differance
    By BigEye64 in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 11-21-2008, 12:26 AM
  6. Using Rank with ties and spliting the differance
    By assws in forum Excel General
    Replies: 6
    Last Post: 07-29-2005, 10:09 AM
  7. Formula for finding the differance between two times
    By DP01 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-03-2005, 09:06 PM

Tags for this Thread

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