What does =B11*$C$4 mean?

[David Deley]

=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?

 

[Gord Dibben]

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

 

[Barb Reinhardt]

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.