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
|