Dan,
It's used when you don't want something to change. Suppose in cell C1 you
have a formula of =A1*B1. If you wanted to multiply every number in Col A by
B1 and tried to copy the formula down it wouldn't work because the formula
would change to =A2*B2 for C2 and A3*B3 for cell C3. If you use =A1*$B$1 it
would copy down as A1*$B$1 yet.

"Dan" wrote:

The $ is used in formulas and other expressions to indicate an *Absolute*
reference as opposed to a *Relative* reference to a cell. Relative references
change when copied from one cell to another, and this is how Excel works by
default. Absolute references do not change when copied from one location to
another.

BTW- No offense, ww, but in the last line of your reply,
<<If you use =A1*$B$1 it would copy down as A1*$B$1 yet.,
as the expression is written here, the reference to A1 *would* change to A2,
A3, A4, etc., although the reference to $B$1 would, as you say, remain fixed
on that specific cell.

HTH |:)


"Dan" wrote:

So it would. I should probably proofread this stuff before I post it :)

"CyberTaz" wrote:

The $ is used in formulas and other expressions to indicate an *Absolute*
reference as opposed to a *Relative* reference to a cell. Relative references
change when copied from one cell to another, and this is how Excel works by
default. Absolute references do not change when copied from one location to
another.

BTW- No offense, ww, but in the last line of your reply,
<<If you use =A1*$B$1 it would copy down as A1*$B$1 yet.,
as the expression is written here, the reference to A1 *would* change to A2,
A3, A4, etc., although the reference to $B$1 would, as you say, remain fixed
on that specific cell.

HTH |:)


"Dan" wrote: