Excel Formula Problem

  • Thread starter Thread starter cmiz
  • Start date Start date
C

cmiz

This is probably a stupid question. I want to take a
column of prices A10, A11, A12 etc.. and apply a discount
%. Example: I have .65 sitting in a rouge cell say C3. My
equation for B10 is =A10*C3. As I try to copy this
equation to B11, B12 and so on, the equation chages C3 to
C4, C5, etc. I want to be able to cpy this equation to B11
B12 and so on with the C3 remaining consistant. How can I
do this?
 
Hi
try
=A10*$C$3
and copy down

you may also search for absolute/relative references in the Excel help
for more information about this syntax
 
Just lock the reference with $ signs, eg:-

=A10*$C$3

See Help for Absolute and Relative references.
 
-----Original Message-----
This is probably a stupid question. I want to take a
column of prices A10, A11, A12 etc.. and apply a discount
%. Example: I have .65 sitting in a rouge cell say C3. My
equation for B10 is =A10*C3. As I try to copy this
equation to B11, B12 and so on, the equation chages C3 to
C4, C5, etc. I want to be able to cpy this equation to B11
B12 and so on with the C3 remaining consistant. How can I
do this?
.
Put your cursor between the letter and number and hit F4.
Click to expand...
This "fixes" the location of the cell your are referencing.
You can also manually enter the dollar sign ($) before each
or either letter/number. If you want to set the column
only and let the row change, just put the dollar sign in
front of the letter, and so on...
 
Back
Top