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???