Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculation question (excel 2003)

    I'm trying to calculate in a cell the number of late Trancactions.

    Percentage on time # Transactions
    99.99% 33960 = X amount of Transactions that where late.

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Calculation question (excel 2003)

    If cells:
    A1: 99.99%
    A2: 33960

    won't this be:
    A3 = (1-A1)*A2
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Calculation question (excel 2003)

    Say that percentage on time is in A1 and number of transactions in A2.
    The following formula will return the number of transactions that were late:

    =(100%-A1)*A2

    If you want to ensure that it is a whole number:

    =ROUND((100%-A1)*A2,0)

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculation question (excel 2003)

    That does work Hans but is there a way to show the number of transaction that were not late? I think thats what I really need. IN this case it would be 33957.
    Thanks..


    Percentage on time Total Transactions Transactions on time
    A1 99.99% A2 33960 A3 = X (in this case 33957)

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Calculation question (excel 2003)

    That would be

    =A1*A2

    or to round to a whole number

    =ROUND(A1*A2,0)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •