Percentage changes

Posted by Lina on October 28, 2001 6:49 AM

Hi,
How can I find out the average percentage changes (either increase or decrease) e.g the average % changes between A1 and A10? Thanks for reading.

Posted by EDDIE G on October 28, 2001 7:19 AM

to find the pct of change between A1 and A10 use the following:

in whatever cell you want the result to show type:
=round(sum((a1/a10)-100%,3)
this will show the pct of change that A1 is from A10 rounded off to three places.

Eddie