1. 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. Re: Calculation question (excel 2003)

If cells:
A1: 99.99%
A2: 33960

won't this be:
A3 = (1-A1)*A2

3. 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. 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. 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
•