View Single Post
  #2   Report Post  
RagDyeR
 
Posts: n/a
Default

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