=C10/$C$2

The $ signs "fix" C2 so it won't change as you copy.

See help on relative and absolute references.


Gord Dibben MS Excel MVP

On Thu, 19 Mar 2009 16:56:09 -0700, BTM
wrote:

I have a worksheet in which cell C2 has number e.g. 253,754.

In other rows I'm placing different values in the C column e.g. C10=8,000;
C13=5,000; C16=12,500; C19=2,750; C22=11,000 etc.

I want the B10 cell to calculate the percentage C10 is to C2 so I input the
formula =C10/C2 into B10.

When I copy the formula in B10 (=C10/C2) to the rows that have other values
in the C column such as C13, C16, C19, C22 it changes the numerator and
denominator so what shows up in B13 is =C13/C5. I would like the formula to
change the numerator to the corresponding row but keep the denominator as C2.
I would like the formula to change to =C13/C2, =C16/C2, =C19/C2, =C22/C2,
etc. How can I copy the formula in B10 to other cells to accomplish this?

I'm using Office 2003.

Thanks for your help.