| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does a $ mean in a calculation, Example =+D9*$E$12*$B$3
I can't locate any information on the use of $ signs in formulas
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What does a $ mean in a calculation, Example =+D9*$E$12*$B$3
It refers to absolute referencing.
for example if you type a formula =(A1) and drag it down the formula changes to =(A2) etc but if you type =($A$1) and drag it down it always refers to the Cell A1 "mbamap" wrote: I can't locate any information on the use of $ signs in formulas |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What does a $ mean in a calculation, Example =+D9*$E$12*$B$3
It's an absolute reference. If the formula were copied to the right or down,
the cell references E12 and B3 would not change. However, since D9 has no dollar signs, it is a relative reference, and so if the formula were copied to the right, it would read E9, and if it were copied down the formula would read D10. Dave -- Brevity is the soul of wit. "mbamap" wrote: I can't locate any information on the use of $ signs in formulas |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I change the default manual calculation as automatic | Excel Discussion (Misc queries) | |||
| Open CSV causes calculation in manual calc mode | Excel Discussion (Misc queries) | |||
| Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
Linear Mode
