Hi,
I need a formula to accomplish the following:
X - Initial amount
Y - Factor
X * Y = A
A * Y = B
B * Y = C
C * Y = D
D * Y = E
F * Y = F
F * Y = G
I need a formula that can sum X+the sum of A-F.
For Example
X = 10,000
Y = .3
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
I'm looking for a formula that will output 14,285.4. It doesn't have to be 7 iterations, but would like at least 5. Any ideas?
I need a formula to accomplish the following:
X - Initial amount
Y - Factor
X * Y = A
A * Y = B
B * Y = C
C * Y = D
D * Y = E
F * Y = F
F * Y = G
I need a formula that can sum X+the sum of A-F.
For Example
X = 10,000
Y = .3
10000 | 0.3 | 3000 |
3000 | 0.3 | 900 |
900 | 0.3 | 270 |
270 | 0.3 | 81 |
81 | 0.3 | 24.3 |
24.3 | 0.3 | 7.3 |
7.3 | 0.3 | 2.2 |
2.2 | 0.3 | 0.7 |
sum= | 14285.4 |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
I'm looking for a formula that will output 14,285.4. It doesn't have to be 7 iterations, but would like at least 5. Any ideas?