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.