View Single Post
 
Old 06-26-2012, 07:15 AM
jprt68 jprt68 is offline Windows Vista Office 2010 32bit
Novice
 
Join Date: Jun 2012
Posts: 1
jprt68 is on a distinguished road
Default 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?
Reply With Quote