beancounter
Board Regular
- Joined
- Oct 30, 2002
- Messages
- 111
Thanks for your patience!
I have a row with amounts from the previous 10 years of budget amounts (i.e., c1 = 100 d1 = 200 ...) I also have the same years actual amounts below them, (i.e., c2 = 90 d2 = 150 ...) and the next row calculates the difference, (i.e., c3 = c1-c2) and a percentage change calculated for each two years i.e., d4 = (c1-d1)/c1, d5 = (d1-e1)/d1 ...
that part is simple but, I want to get an average of the percentage changes over the ten years. I figured out two ways of doing it and not surprisingly come up with two different answers. Which is correct:
=AVERAGE(d4:m14)
OR
=((c3-m14)/c3)/10
Any help is appreciated
I have a row with amounts from the previous 10 years of budget amounts (i.e., c1 = 100 d1 = 200 ...) I also have the same years actual amounts below them, (i.e., c2 = 90 d2 = 150 ...) and the next row calculates the difference, (i.e., c3 = c1-c2) and a percentage change calculated for each two years i.e., d4 = (c1-d1)/c1, d5 = (d1-e1)/d1 ...
that part is simple but, I want to get an average of the percentage changes over the ten years. I figured out two ways of doing it and not surprisingly come up with two different answers. Which is correct:
=AVERAGE(d4:m14)
OR
=((c3-m14)/c3)/10
Any help is appreciated