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
|