copying a formula

[Guest]

I have aproblem with a discounting formula.
In Column B, I have 200 long distance rates starting on Row B3.
In Cell C2, I wish to enter my discount value as a percentage. ( i.e. 85% of
'B3')
This works fine.
If I try to copy the formulain cell 'C3' : =(B3*C2) to the rest of
Column C, the copy /Paste feature keeps changing the multiplier as the sells
increase.
I.e. in cell C4, the pasted formula is: = (B4*C3). I only want each of
my formulas to refernce cell C2.
How can I fix this without manually changing each copied value to multiply
by cell C2?

 

[JulieD]

Hi

in the first line of your formula use $C$2 instead of C2 (this makes this
reference "absolute" and will not change when you copy it down a column) and
then copy this down all the rest - you should be able to copy the formula
down using the autofill handle - make sure the formula copies down to C4 and
then in C4, move your mouse over the bottom right hand corner of the cell
until you see a +, double click on the + and the formula should be
replicated down the column.

Hope this helps
Cheers
JulieD

 

[Guest]

hi,
use absolute referencing by adding dollar signs

$C$2

without dollar signs is relative referencing.

 

[Gordon]

I have aproblem with a discounting formula.
In Column B, I have 200 long distance rates starting on Row B3.
In Cell C2, I wish to enter my discount value as a percentage. ( i.e. 85% of
'B3')
This works fine.
If I try to copy the formulain cell 'C3' : =(B3*C2) to the rest of
Column C, the copy /Paste feature keeps changing the multiplier as the sells
increase.
I.e. in cell C4, the pasted formula is: = (B4*C3). I only want each of
my formulas to refernce cell C2.
How can I fix this without manually changing each copied value to multiply
by cell C2?

In Cell C£ type the formula =B3*$C$2
The "$" sign is an absolute reference as opposed to a relative
reference, and when you copy the formula down, $C$2 will stay exactly
the same.

HTH