View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett
 
Posts: n/a
Default Excel Repeating Formula

try this where j8 has your 54k and the ^2 is for 2. Chg to whatever desired.
65340

=J8*1.1^2
--
Don Guillett
SalesAid Software

"cbrock" wrote in message
...
I am trying to creat a formula that will look at a value entered in one
cell,
(ex. 10%), then look at another value, (ex. $54K), and multiply by the
first
value. This will equal $5400, then the formula needs to ad the $5400 to
the
first $54K and equal $59,400. This part I understand how to do. I now need
how to get the new total of $59,400 to auto repeat the process.( Ex. 54K *
10% = 5400 + 54000 = 59,400 * 10% = 5940 + 59400 = 65340 * 10% = etc etc.)
A
compiling equation.