What does $ mean?

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


[email protected]...
 
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 :)
------------------------------­------------------------------­----------------
 
Top