|Posted by:||Rhys (cird…@optusnet.com.au)|
|Date:||Thu, 9 Oct 2003|
Assume an investment sum.
Assume two columns.
Column A has a list of monetary figures increasing in
value as they go down the column.
Column B is a percentage of the increases the cells in
For example Cell A would have value of $5000.00
Cell A2 $5140.00
Cell lA3 $5216 and so on own the column
Cell B1 would show a nil value as it is related to Cell A1
Cell B2 would show a % value of % value of $140.00 as it
related to Cell A1
Cell B3 would show a $216.00 as it related the Cell A1
In other words Cell A1 must be related to all the cells
in Column B.
I want to set the formula in Cell B2 so that when I drag
down the formula it reflects Cell A1 right down the
column. I have an idea the $ sign or # sign is inserted
somewhere primary cell (B2)
How is this done?