Need Help Programming

R

RandyJ

Yes, I want to use a variable inflation rates.
I don't want to see each years figure.

If I was using a calculator, I would do 100*1.03*1.03*1.03*1.03*1.03,
if I was doing that for 5 years and then I want to store that value i
a cell.

I don't want any cells to have fixed values.
My material of var.
My percent is var.
My number of years if var.

Thanks!
 
A

AlfD

Hi!

That's quite a bit different from where I thought you were;)

The following gives you more scope:

A1 .... "Starting amount"
A2 ......100
A3 ......."After year:"
B1 ......Inflation in year 1
B2....... leave empty for now
B3....... =A2*(1+B2)
C1 ......copy B1 across maybe 10 columns The 1 should become 2,3 etc)
C2....... leave empty for now
C3.......copy B3 across maybe 10 columns.

Format row 2 as percentage with 1 d.p.
Format row 3 as ccurrency (nearest dollar? Nearest cent?)
Format A2 same as row 3.

Now, if you put inflation amounts in any of B2,C2 ..... the new cos
rate will show
 
A

AlfD

Hi!

We crossed in the post.

If all you need is the standard compound interest formula:

amount=principal*(1+int)^years

then put principal in A1
Years in A2
Interest rate in A3
In A4 put = A1*(1+A3)^A2

Take care that A3 is 0.03 if you want 3% etc
 
Top