Forum Discussion
Common Multiplier for Each Column while multiplying from a different column
I am trying to rebuild my price Structure for my products. I have a cost in the first row and need it to follow one column all the way to the bottom of the structure. What is happening is the cells are changing and progressing, but I don't need that. It is causing a lot of editing for each column to get the multiplier to stay the same while the denominator moves down another column and places the result in the according cell as it moves down in another column.
Such as =D1*C2 for cell D2, and then D3 would be =D1*C3, then D4 would be =D1*C4, and so on.....
Byselecting each of the cells propagating down in the column, the "D1" is staying the same. Help!!
1 Reply
Roger_Penny You need to fix the reference to D1 but putting $ signs before both the column and row identifier. The formula would then look like this:
=$D$1*C2
Copy this one all the way down and you'll note the D1 is fixed and that C2 becomes C3, C4 etc.
Learn more about relative and absolute cell references in the article linked to below.
Alternatively, give cell D1 a name in the Name Manager or by typing it directly in the Name Box (in the top left just above the grid where it says D1 when you have selected that cell. Just type UnitCost in that box and press enter. Now you can use that name in a formula like this:
=UnitCost*C2
