View Single Post
  #17   Report Post  
Posted to microsoft.public.excel.worksheet.functions
denni taylor denni taylor is offline
external usenet poster
 
Posts: 1
Default auto populate from one cell to multiple columns

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