How do I fill down keeping one cell calculation from changing in .
 

If I have a calculation I want to fill down which has multiple calculations.
How do I fill it down keeping one of the calculations constant. Meaning one
of the calculations always uses the same cell for a calculation, it doesn't
change as the cells go down.

eg =SUM(A2*F13-J13) I wand to keep the A2 all the way down but want the
others
to change as it is filled down.

Thanks, WC

Look up About cell and range references in the HELP files.

And try this:

=SUM($A$2*F13-J13)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"WC" wrote in message
...
If I have a calculation I want to fill down which has multiple calculations.
How do I fill it down keeping one of the calculations constant. Meaning one
of the calculations always uses the same cell for a calculation, it doesn't
change as the cells go down.

eg =SUM(A2*F13-J13) I wand to keep the A2 all the way down but want the
others
to change as it is filled down.

Thanks, WC

Thanks RD for bailing out a rookie!!

"RagDyeR" wrote:

Look up About cell and range references in the HELP files.

And try this:

=SUM($A$2*F13-J13)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"WC" wrote in message
...
If I have a calculation I want to fill down which has multiple calculations.
How do I fill it down keeping one of the calculations constant. Meaning one
of the calculations always uses the same cell for a calculation, it doesn't
change as the cells go down.

eg =SUM(A2*F13-J13) I wand to keep the A2 all the way down but want the
others
to change as it is filled down.

Thanks, WC