Formulas

  • Thread starter Thread starter Kim
  • Start date Start date
K

Kim

I know this is probably a very basic question but hope someone can help. In
reference to copying formula... Lets say, for example that I have a number in
C1 and I want the items in A3, A4, A5.. to multiply times c1 and produce the
answer in B3, B4, B5.. I know the basic formula in B3 is =A3*C1 However if
i just copy that formula and paste it in B4 it changes the formula to =A4*C2
when I want it to keeo the C1. Does that make sense?

How do I keep the formula to keep referencing the C1 cell. I tried Paste
special, formula only, etc but it keeps carrying the formula down to C2 or C3.
 
You need to use what's called an "absolute reference". To lock formula on
column
=$A1
copying down changes row, copying across has no change
=A$1
copying down changes nothing, copying across changes column.

For your situtation:
=A3*$C$1
will work, or
=A3*C$1

either will do.
 
Genius - thank you

Luke M said:
You need to use what's called an "absolute reference". To lock formula on
column
=$A1
copying down changes row, copying across has no change
=A$1
copying down changes nothing, copying across changes column.

For your situtation:
=A3*$C$1
will work, or
=A3*C$1

either will do.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*
Click to expand...
 
Back
Top