The equation I use is:
=((y/x)^(1/n))-1
where
y= value in final year
x=value in 1st year
n=# of years
--
Thanks


"David Biddulph" wrote:

If you're saying 5 years, it's
=(10000/5000)^(1/5)-1 formatted as percentage.
--
David Biddulph

"Johan" wrote in message
...
Hi,

I have office 2003. I need an excel formula to calculate Average
percentage
increase.
Example start wage 5000 current wage 10000
Start date 01/02/2004 (1st Feb) current date 03/03/2009 (3rd March)
length of service 5 years
What was the average annual % increase received to go from 5000 to 10000
in
5 years. This needs to take compound growth into account
(the xirr formula does not work)

Please help

Johan Campbell