Bob I wrote:
Divide Year 2 by Year 1, subtract 1 and multiply by 100 to get the
percentage increase from year 1 to year 2

Jessica wrote:

I have in the Year 1 $212,360 Year 2 $398,950 Year 3 $420,950, i would
like to know the difference between those three amounts, but the
answer to be in percentage.

"Niek Otten" wrote:


I don't think there is a definition for "the difference between three
amounts".
Please explain what you require

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Jessica" wrote in message
...
| How do i calculate the difference between three amounts in percentage.



and then, of course, repeat the process for years 2 and 3.

Bill