Keep cell in formula constant
Say I have 2 columns a and b, as well as an Add column for example:
a b add
---------------
4 2
3 4
1 2
For the Add formula I would type =A2+B2 into the first cell, then just drag this down so that all other rows have appropriate formulas =A3+B3, =A4+B4 ... etc.
What if I had a forth column, e.g. "Multiply by Price" where Price is stored in another cell, e.g. F3.
a b add Multiply by Price
------------------------------------
4 2 6
3 4 7
1 2 3
Price
--------
7.5
So in the first "Multiply by Price" cell I would type =F3*A3
I want to be able to drag this down so that the formulas change to =F3*A4, =F3*A5 .... etc where the F3 remains constant.
What do I do to the formula to do this?
|