why would you use "=&" within a formula?
The dollar symbols turn the cell reference I2 into an absolute
reference, so it will not change if the formula is copied anywhere
else - it will always refer to cell I2.
Hope this helps.
Pete
On Jun 6, 9:13*pm, helpwithdeletion
wrote:
I am trying to look at a formula within an excel document and it has
"=$I$2*(...)
What purpose does the $ represent?
|