| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what does $ do in an xl formula
I HAVE A cell WITH A FORMULA =+D40/$O$2 Can someone tell me what the $ does?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
what does $ do in an xl formula
Read your help file on relative reference and absolute reference.
-- John C "notsure" wrote: I HAVE A cell WITH A FORMULA =+D40/$O$2 Can someone tell me what the $ does? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
what does $ do in an xl formula
Those $ signs tell excel not to change that address if you copy that formula to
other cells. Look in excel's help for "absolute references" notsure wrote: I HAVE A cell WITH A FORMULA =+D40/$O$2 Can someone tell me what the $ does? -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
what does $ do in an xl formula
The $ basically locks down the column or row after it - so, in your example
below the $ locks column O and row 2 - if you were to copy the formula down one row it would look at D41 (instead of D40) but it would still look at O2 because that has been locked.... Hope that makes sense!! "John C" wrote: Read your help file on relative reference and absolute reference. -- John C "notsure" wrote: I HAVE A cell WITH A FORMULA =+D40/$O$2 Can someone tell me what the $ does? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
