What does a $ mean in a calculation, Example =+D9*$E$12*$B$3
 

I can't locate any information on the use of $ signs in formulas

What does a $ mean in a calculation, Example =+D9*$E$12*$B$3
 

It refers to absolute referencing.

for example if you type a formula =(A1) and drag it down the formula changes
to =(A2) etc but if you type =($A$1) and drag it down it always refers to the
Cell A1

"mbamap" wrote:

I can't locate any information on the use of $ signs in formulas

What does a $ mean in a calculation, Example =+D9*$E$12*$B$3
 

It's an absolute reference. If the formula were copied to the right or down,
the cell references E12 and B3 would not change. However, since D9 has no
dollar signs, it is a relative reference, and so if the formula were copied
to the right, it would read E9, and if it were copied down the formula would
read D10.

Dave
--
Brevity is the soul of wit.


"mbamap" wrote:

I can't locate any information on the use of $ signs in formulas