Formula with fixed details
 

I am creating a formula, whereby each person has a different percentage.

At the beginning of the chart, I will insert the correct percentage and my
formula will point to that percentage, in order that I may use the same
formula across the board.

My question is.....when you copy the formula down, it then points to the
incorrect cell, as it is now below the cell. Is there a way to copy the
formula down, with "fixing" the cell positions of certain information....if
that makes sense???

Formula with fixed details
 

Use an absolute address. In stead of using eg A5 as the cell pointer, use
$A$5.
If you want to fix only the column part, then use $A5, and if you want to
fix only the row part, use A$5

--
Hth

Kassie Kasselman
Change xxx to hotmail


"Shaz" wrote:

I am creating a formula, whereby each person has a different percentage.

At the beginning of the chart, I will insert the correct percentage and my
formula will point to that percentage, in order that I may use the same
formula across the board.

My question is.....when you copy the formula down, it then points to the
incorrect cell, as it is now below the cell. Is there a way to copy the
formula down, with "fixing" the cell positions of certain information....if
that makes sense???

Formula with fixed details
 

You're a star...thanks!

"kassie" wrote:

Use an absolute address. In stead of using eg A5 as the cell pointer, use
$A$5.
If you want to fix only the column part, then use $A5, and if you want to
fix only the row part, use A$5

--
Hth

Kassie Kasselman
Change xxx to hotmail


"Shaz" wrote:

I am creating a formula, whereby each person has a different percentage.

At the beginning of the chart, I will insert the correct percentage and my
formula will point to that percentage, in order that I may use the same
formula across the board.

My question is.....when you copy the formula down, it then points to the
incorrect cell, as it is now below the cell. Is there a way to copy the
formula down, with "fixing" the cell positions of certain information....if
that makes sense???