View Single Post
  #1   Report Post  
WC
 
Posts: n/a
Default 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