#1




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? 
#2




Hi,
You can lock the column and row references by putting a $ sign in front of them. This is called absolute referencing. (a) This will lock the F and the 3 so they will not adjust if you fill either across or down. =$F$3*A3 (b) This will lock the F so it will not adjust if you fill across. The 3 will still adjust when you fill down. =$F3*A3 (c) This will lock the 3 so it will not adjust if you fill down. The F will still adjust when you fill across. =F$3*A3 In this case you can use either (a) or (c) since it is the 3 you want to lock as you fill down. 
Tags 
cell, formula, formulas 
Thread Tools  
Display Modes  

Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Use formula to copy cell formats also  mike_abc  Excel  10  12102011 01:55 AM 
need to check whether cell contains formula  etodem  Excel  2  10232010 07:33 PM 
Formula in a Cell with condition?  Learner7  Excel  1  07192010 10:10 AM 
How can I write the following (whole) formula in a single cell?  Learner7  Excel  1  07192010 10:06 AM 
Protect formula in cell?  markg2  Excel  4  05242010 11:50 AM 