Average Percentage help please
=AVERAGE(G4,G8,G12)
But, be careful! The average of the percentages is not the same as the
average percentage of the underlying figures!
It depends on what exactly you're trying to achieve. If in doubt, post again
in this thread, with some examples of the underlying data as well.
--
Kind regards,
Niek Otten
"kyleuk via OfficeKB.com" <u15338@uwe wrote in message
news:56ab69e9838b0@uwe...
Hi I have a row that shows payout percentages from a fruit machine every
time
I record in & out data
could anyone help me with the formula needed to show an average percentage
payout.
IE:
G4 = 88%
G8 = 78%
G12 = 91%
How would I work out what the average percentage is ?
All previous help much appreciated.
|