=(A4-A1)/A1

Format as %

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Arealtor12345" wrote in message
...
I have 4 years of annual figures that I need to show a Vertical Growth
Percentage for...I am STUCK on the formula to use!
Example:
year 2001: $568,808.24
year 2002: $557,311.98
year 2003: $649,831.71
year 2004: $666,971.40
The resulting Vertical Growth should be 17.26%

How did they come up with this percentage using a formula???