Dollar signs
 

This may sound like a trival question

What are the Dollar sign around the column letter (ex. $a$1) that I see in
some formulas on excel sheets I get from other people. I tried looking it up
in help but couldn't find anything.

Just wondering

"Lee" wrote in message
...
This may sound like a trival question

What are the Dollar sign around the column letter (ex. $a$1) that I see in
some formulas on excel sheets I get from other people. I tried looking it
up
in help but couldn't find anything.

Just wondering

A dollar sign means an absolute cell reference. Lookup cell references in
Help.

Lack of a dollar sign means relative cell reference.

For example: you enter a formula in a cell C1 such as: =$A$1*B1. If you
then copied that formula to cell C2, the result would be =$A$1*B2. The
absolute reference remains the same while the relative references changes.
Each cell in column C is the product of the corresponding cell in column B
times the same number which is in cell A1.

Don

hi,
dollar signs signifies an absolute reference ie one that never changes when
you copy it to another place as opposed to a reletive reference or one the
does change when you copy it to another place.

regards
FSt1
"Lee" wrote:

This may sound like a trival question

What are the Dollar sign around the column letter (ex. $a$1) that I see in
some formulas on excel sheets I get from other people. I tried looking it up
in help but couldn't find anything.

Just wondering

Thanks

"Don MI <" wrote:


"Lee" wrote in message
...
This may sound like a trival question

What are the Dollar sign around the column letter (ex. $a$1) that I see in
some formulas on excel sheets I get from other people. I tried looking it
up
in help but couldn't find anything.

Just wondering

A dollar sign means an absolute cell reference. Lookup cell references in
Help.

Lack of a dollar sign means relative cell reference.

For example: you enter a formula in a cell C1 such as: =$A$1*B1. If you
then copied that formula to cell C2, the result would be =$A$1*B2. The
absolute reference remains the same while the relative references changes.
Each cell in column C is the product of the corresponding cell in column B
times the same number which is in cell A1.

Don

If you feel the need to ask it's not trivial. If you don't ask you wont
know.

The $ fixes the dimension in which the elements of a formula will change
when it is copied to other cells.

=a1
wherever you copy it to the two elements of the formula will change by the
same number of cells (left, right, up, down)

=$a1
wherever you copy it to the first element will always refer to column A and
the reference to the row will change

=a$1
wherever you copy it to the second element will always refer to row 1 and
the reference to the column will change

=$a$1
wherever you copy it to it will always refer to A1

Regards.

Bill Ridgeway
Computer Solutions

"Lee" wrote in message
...
This may sound like a trival question

What are the Dollar sign around the column letter (ex. $a$1) that I see in
some formulas on excel sheets I get from other people. I tried looking it
up
in help but couldn't find anything.

Just wondering