copying a formula
 

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?

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


"BigWylie1" wrote in message
...
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?

hi,
use absolute referencing by adding dollar signs

$C$2

without dollar signs is relative referencing.

-----Original Message-----
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?


.

BigWylie1 wrote:
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

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk