Difference between three numbers in percentage

  • Thread starter Thread starter Jessica
  • Start date Start date
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


| How do i calculate the difference between three amounts in percentage.
 
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.
 
Divide Year 2 by Year 1, subtract 1 and multiply by 100 to get the
percentage increase from year 1 to year 2
 
Or don't multiply by 100 but format as Percentage

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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
| >>
| >>
| >>| How do i calculate the difference between three amounts in percentage.
| >>
| >>
| >>
|
 
Bob said:
Divide Year 2 by Year 1, subtract 1 and multiply by 100 to get the
percentage increase from year 1 to year 2
Click to expand...
and then, of course, repeat the process for years 2 and 3.

Bill
 
Back
Top