What does =B11*$C$4 mean?
 

=B11*$C$4

I get the cell value equals cell B11 times——then what's the $ mean,
$C$4? I think it means use the value in cell C4, but what do the $ mean?

What does =B11*$C$4 mean?
 

The $ signs make a cell reference Absolute so it does not change as you copy
the formula.

=B11*$C$4 will increment as =B12*$C$4 as you drag/copy down the column.

The B11 will increment and $C$4 will remain fixed.

See help on absolute and relative cell references.


Gord Dibben MS Excel MVP

On Sun, 22 Nov 2009 11:52:37 -0800, David Deley wrote:

=B11*$C$4

I get the cell value equals cell B11 times——then what's the $ mean,
$C$4? I think it means use the value in cell C4, but what do the $ mean?

What does =B11*$C$4 mean?
 

Why don't you try to copy te cell down one row or over one row. You'll see
B11 changing, but $C$4 doesn't change. It's absolute referencing.
--
HTH,

Barb Reinhardt



"David Deley" wrote:

=B11*$C$4

I get the cell value equals cell B11 times€”€”then what's the $ mean,
$C$4? I think it means use the value in cell C4, but what do the $ mean?
.