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?