View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default 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