cell to remain constant value in column

**yikes** · 10-14-2007, 08:37 PM

I havent used excel in a while and I'm using $ symbol (as a formula) somehow wrong...

Its my desire to keep the same value (or same cell) as a constant value in my formula down my column. But as a result of my misuse of the correct placement for "$" it isnt keeping this value for each row when I drag formula down my column...please help...yikes!

Thanks everyone....

**yikes** · 10-14-2007, 08:59 PM

I havent used excel in a while and I'm using $ symbol (as a formula) somehow wrong...

Its my desire to keep the same value (or same cell) as a constant value in my formula down my column. But as a result of my misuse of the correct placement for "$" it isnt keeping this value for each row when I drag formula down my column...please help...yikes!

Thanks everyone....

**yikes** · 10-14-2007, 09:11 PM

I'm using $ symbol (as a formula) somehow wrong...

Its my desire to keep the same value (or same cell) as a constant value in my formula down my column. But as a result of my misuse of the correct placement for "$" it isnt keeping this value for each row when I drag formula down my column...please help...yikes!

Thanks everyone....

**Trebor76** · 10-14-2007, 09:11 PM

Hi there,

Enter =B4*$C$3 in cell C4 and copy down as required.

HTH

Robert

**mikerickson** · 10-14-2007, 09:27 PM

Each of these act differently: A1 $A1 A$1 $A$1

They can be read where "$" = "always" as in

A3 = column A, row 1
$A1 = always column A, row 1
A$1 = column A, always row 1
$A$1 = always column A, always row 1

Does that help?

**davesexcel** · 10-14-2007, 11:55 PM

try
=b4*$C$3

**VBA Noob** · 10-15-2007, 03:48 AM

Thanks Dave.

yikes,

Please read forum rules below. Duplicate posts are not permitted as it waste everyones time. I've merged your 3 posts this time but next time they will be deleted

VBA Noob