increase value exponentaily

January 13, 2012 at 07:28:38
Specs: Windows 7, 232 GB /128MB
Hi Everyone,

I would like to project a 3.5% increase each year for several years. How would I write this fromula?

Year Amount
A1 2012 B1 $100
A2 2013 B2 $103.50
A3 2014 B3 $107.12

See More: increase value exponentaily

Report •

January 13, 2012 at 08:47:53
With $100 in B1, enter this in B2 and drag it down:


If you want to vary the percentage to see the effect it has, you can do this:

Enter 3.5% in a cell, e.g. C1

Then enter this in B2:


Now you can change the percentage in C1 and see how it impacts the progression of values in Column B.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question