K
KH_GS
What does the $ mean in the cell reference
D
Don
The $ sign indicates the when filling either vertically or horizintally,
that the index immediately after the sign (either a letter or number) will
not change. This is useful when each cell in a column for instance, needs
to use the one cell only to multiply by. For instance in "2" is the value
of cell A1, and in A2 thru A10 contains other values, and B2 contains the
formula " A2*A$1", and this cell is filled down to cell B10, then cell B10
will show the value (A10*A1). Without the "$" sign, the value of B10 will
show the value of (A10*A9)
Don
(e-mail address removed)...
that the index immediately after the sign (either a letter or number) will
not change. This is useful when each cell in a column for instance, needs
to use the one cell only to multiply by. For instance in "2" is the value
of cell A1, and in A2 thru A10 contains other values, and B2 contains the
formula " A2*A$1", and this cell is filled down to cell B10, then cell B10
will show the value (A10*A1). Without the "$" sign, the value of B10 will
show the value of (A10*A9)
Don
(e-mail address removed)...
K
Ken Wright
Nice explanation to be found here
http://cpearson.com/excel/relative.htm
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------
http://cpearson.com/excel/relative.htm
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------