Start value assumed in B2: 800

In C2: =B2*8%
In D2: =C2*80%
Copy C2:D2 down

In B3: =SUM(B2:C2)
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,400 Files:358 Subscribers:55
xdemechanik
---
<denni taylor wrote in message ...
Hi Max
Can you please help me with a problem, I need to enter data in one cell
'2' and then have it look at an amount in one column, do a multiplication
in two columns and then in the next row use the data from the row above.
800 x 8% = 64 (val x 8 = growth)
64 xx 80% = 51 (growth x unlock)
and put the 864 on the next line and go again.
Is there anyway of doing this Max?
Would greatly appreciate any help
Regards Denni
'2'
Value Growth Unlock
Start $800 $64 $51
Y1 $864 $69 $55
Y2