excel formula

[Clara Campbell]

How do I keep a segment of a formula not change.
Example: cell B1 is a number
cell B2 is(B1/4)
Cell B3 is the value of (B2*C3)

My problem is I want to copy cell B3 to the entire B
column with the formula keeping B2 the same and changing
C3, to C4, C5 etc. exp. (B2*C4)
(B2*C5)
(B2*C6)
Please help.

Regards,
Clara Campbell

 

[Anon]

How do I keep a segment of a formula not change.
Example: cell B1 is a number
cell B2 is(B1/4)
Cell B3 is the value of (B2*C3)

My problem is I want to copy cell B3 to the entire B
column with the formula keeping B2 the same and changing
C3, to C4, C5 etc. exp. (B2*C4)
(B2*C5)
(B2*C6)
Please help.

Regards,
Clara Campbell

Use $B$2 instead of B2.

 

[Andy B]

Clara

Make your cell reference absolute.
Your formula for B3 should be
=$B$2*C4
This will always use cell B2, wherever you copy it to.

Andy.