why would you use "=&" within a formula?

[helpwithdeletion]

I am trying to look at a formula within an excel document and it has
"=$I$2*(...)

What purpose does the $ represent?

 

[Pete_UK]

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

 

[Niek Otten]

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


|I am trying to look at a formula within an excel document and it has
| "=$I$2*(...)
|
| What purpose does the $ represent?

 

[Niek Otten]

<=$A$!>

should have been

=$A$1

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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
|
|
| ||I am trying to look at a formula within an excel document and it has
|| "=$I$2*(...)
||
|| What purpose does the $ represent?
|
|