what does $in a cell do?
Hi,
$ in a cell refers to Absolute reference and not relative reference. The
pointer to the cell value remains constant.
For example: It is like Pointer to an address in arrays in C programming. In
relative refernce the value will change based on the changing reference.
Note: You can use also use named definition as pointer to address. The named
definition will be store the absolute address of the cell or range of cells
as reference.
Challa Prabhu
"cj" wrote:
What does a $ in a cell do?
Example ($A1)
|