- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2003 October
- constant cell

Subject: | constant cell |

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

Column A.

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?

TIA

- Re: constant cell posted by Paul on Thu, 9 Oct 2003