Calculation question (excel 2003)

Topic

New Reply

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.

Reply | Quote

Replies

If cells:
A1: 99.99%
A2: 33960

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

Reply | Quote

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)

Reply | Quote

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)

Reply | Quote

That would be

=A1*A2

or to round to a whole number

=ROUND(A1*A2,0)

Reply | Quote