| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why would you use "=&" within a formula?
I am trying to look at a formula within an excel document and it has
"=$I$2*(...) What purpose does the $ represent? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
why would you use "=&" within a formula?
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
why would you use "=&" within a formula?
<=$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? | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| any formula to convert numbers in word form, e.g. "2" as "Two"? | Excel Worksheet Functions | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| conditional formula to show "open" or "closed" | Excel Worksheet Functions | |||
Linear Mode
