What does =B11*$C$4 mean?

  • Thread starter Thread starter David Deley
  • Start date Start date
D

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?
 
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
 
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.
 
Back
Top