ExcelBanter - calculate percent change

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - calculate percent change (https://www.excelbanter.com/excel-discussion-misc-queries/270622-calculate-percent-change.html)

sostena romano

calculate percent change

I have a number of tests run in year 2010 and a number of tests run by
June 2011 and i want to calculate the expected change for 2011. How
would I set that up?

Gord Dibben[_2_]

calculate percent change

100 tests in 2010

60 tests by end of june 2011

2 x 60 = 120 projected tests for 2011

20% more than 2010

Surely you want more than that?

Gord

On Mon, 7 Nov 2011 10:21:48 -0800 (PST), sostena romano
wrote:

I have a number of tests run in year 2010 and a number of tests run by
June 2011 and i want to calculate the expected change for 2011. How
would I set that up?

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