ExcelBanter - Find percentage Trend

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Find percentage Trend (https://www.excelbanter.com/excel-worksheet-functions/22268-find-percentage-trend.html)

Gaurav

Find percentage Trend

Hi I have a sales data of following kind
2000 $2,845,100
2001 $3,098,205
2002 $3,445,204
2003 $3,896,526
2004 $4,375,799
I need assistance to find Percentage Trend for past 3 years & 4 years.

CLR

Assuming your data starts with 2000 in A2,
In C3 put this formula and copy down.......
=(B3-B2)/B2

2001 = 9% increase
2002 = 11% increase
2003 = 13% increase
2004 = 12% increase

hth
Vaya con Dios,
Chuck, CABGx3

"Gaurav" wrote in message
...
Hi I have a sales data of following kind
2000 $2,845,100
2001 $3,098,205
2002 $3,445,204
2003 $3,896,526
2004 $4,375,799
I need assistance to find Percentage Trend for past 3 years & 4 years.

All times are GMT +1. The time now is 11:43 PM.