Excel Repeating Formula
 

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.

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.

Excel Repeating Formula
 

Assuming you have 10% in cell A1 and 54000 in B1, in B2 use:
=B1*(1+$A$1)
Then copy from B2 down to as far as you wish.

-Simon

"cbrock" wrote:

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.