Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

What does =B11*$C$4 mean?

0 views
Skip to first unread message

David Deley

unread,
Nov 22, 2009, 2:52:37 PM11/22/09
to
=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

unread,
Nov 22, 2009, 3:01:30 PM11/22/09
to
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 <del...@gte.net> wrote:

>=B11*$C$4
>
>I get the cell value equals cell B11 times��then what's the $ mean,

Barb Reinhardt

unread,
Nov 22, 2009, 3:37:01 PM11/22/09
to
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?

> .
>

0 new messages