<=$A$!

should have been

=$A$1

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Niek Otten" wrote in message ...
| Suppose you have a formula in A1:
|
| =B1
|
| You copy it to A2, it becomes
|
| =B2
|
| Most of the time this is what you require. But sometimes you don't want the reference to change. Then you put this formula in
A1:
|
| =$A$1
|
| If you copy this formula you A2, it remains
|
| =$A$1
|
| You can have both column and row reference be absolute or relative:
|
| =A1
| =$A1
| =$A$!
| =A$1
|
| When you enter or edit a formula, place the cursor on or near a cell reference and hit F4 several times. You can see the
reference
| change from relative to the other options.
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
|
| "helpwithdeletion" wrote in message
| ...
||I am trying to look at a formula within an excel document and it has
|| "=$I$2*(...)
||
|| What purpose does the $ represent?
|
|