Use of $ symbol while writing a formula?
$ makes your reference constant. For example, if in A1 you have =B1 and
then you copy cell A1 and paste it in A2, your formula will automatically
incriment, therefore being =B2.
In order to make what you paste refer to the same reference, your formula
would have to be =$B1. A $ before the B will maintain your column reference
as "B" regardless of where you copy and paste the formula to. To also
maintain the row reference, you would need a $ next to the number as well.
Ex. =$B$1
You should be able to find help topics in Excel for this.
HTH,
Paul
"YAI" wrote in message
...
|