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

With $100 in B1, enter this in B2 and drag it down: =B1*1.035

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:

=B1*(1+$C$1)

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.

Ask Your Question

Weekly Poll