Multiplying the contents of two cells a variable number of times
 

I'm trying to create a simple final salary calculator.

Current salary is in cell A1
Percentage salary increase per annum in cell A2
Number of years until retirement in cell A3.

So I need to multiply A1 * A2 and the multiply the result by A2 again and
keep repeating that action until the numbe of repeat operations equals the
value in A3.

Any suggestions?


Stephen Brown

Multiplying the contents of two cells a variable number of times
 

Hi Stephen

Try
=A1*(1+A2)^A3

--
Regards

Roger Govier


"Stephen Brown" wrote in
message ...
I'm trying to create a simple final salary calculator.

Current salary is in cell A1
Percentage salary increase per annum in cell A2
Number of years until retirement in cell A3.

So I need to multiply A1 * A2 and the multiply the result by A2 again
and
keep repeating that action until the numbe of repeat operations equals
the
value in A3.

Any suggestions?


Stephen Brown