Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In MS Excel, how do I fill in a column with the same cell from se. | Excel Worksheet Functions | |||
Can an excel cell automatically change fill colors based on values | Excel Discussion (Misc queries) | |||
overtime calculation in 1 cell | Excel Worksheet Functions | |||
Changing Cell Fill Colour | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |