Fill With Constant Cell Reference

  • Thread starter Thread starter Ken Zenachon
  • Start date Start date
K

Ken Zenachon

Say columns A and B are, Cost and Profit, respectively. Cell D1
contains a percentage value representing my profit margin.
Cost is entered manually.
I want to enter into B1 the formula =A1*D1 and then fill that down the
column to calculate my profits. Problem is, when I fill, both cell
references increment, so the next cell down contains the formula
=A2*D2. I want the first cell value to increment, of course, but D1 has
to remain constant. How do I acomplish this withough retyping the
formula for every cell?

KZ
 
In B1 enter =A1*D$1 and then fill down. See help on absolute versus
relative references.

Regards
Rowan
 
Yep, that did it.
Absolute and relative. Man. I was searching help for references on
constant and variable. Right idea, wrong terminology.

Thanks, folks!
 
Back
Top