View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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?