|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.