Formulas

[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.

 

[Luke M]

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.

 

[Kim]

Genius - thank you

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!*