Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does the $ mean when used in a formula please: $G or $3
I am unable to find in search of Help files or Reference online. Here's the
fomula: =SUM($G$3*E14) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does the $ mean when used in a formula please: $G or $3
The dollar sign changes the cell reference from relative to absolute. When
copying formulas containing cells references if you do not include the "$ the reference will change relative to where it is moved from. For example if you had the following formula in cell A5: =Sum(A1:A4) and you copied this formula to cell B5, the formula in B5 would read =Sum(B1:B4), it would have increased by one column since you are pasting one column over. This also holds true to rows. If you had included the "$" in the fomula, =Sum($A1,$A4) and copied it over you would have noticed it would not have changed and the formula in B1 would show = Sum($A1:$A4). "bldurgin" wrote: I am unable to find in search of Help files or Reference online. Here's the fomula: =SUM($G$3*E14) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does the $ mean when used in a formula please: $G or $3
Absolute vs relative reference, if you type in absolute in help there should
be an explanation -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "bldurgin" wrote in message ... I am unable to find in search of Help files or Reference online. Here's the fomula: =SUM($G$3*E14) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does the $ mean when used in a formula please: $G or $3
The $ sign has no impact of the results of a formula, it only impacts the way
that the formula is copied to other cells. A $ sign indicates a fixed (as opposed to a relative) reference in the formula. When you copy a formula to another cell, the column or row reference will not change if there is a $ sign preceding the row or column in the initial formula. . "bldurgin" wrote: I am unable to find in search of Help files or Reference online. Here's the fomula: =SUM($G$3*E14) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does the $ mean when used in a formula please: $G or $3
If you want further explanations, Microsoft Excel's help file has a specifiec
section devoted to the difference between relative and absolute references. "bldurgin" wrote: I am unable to find in search of Help files or Reference online. Here's the fomula: =SUM($G$3*E14) |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does the $ mean when used in a formula please: $G or $3
bldurgin Wrote: I am unable to find in search of Help files or Reference online. Here's the fomula: =SUM($G$3*E14) $ anchors a reference cell to an absolute cell.. for example, if B1's formula is =A1 and you fill drag it down to B2. B2's Formula becomes =A2. Your particular formula tells excel that G3 is an absolute reference and E14 is not. So if you fill drag this formula down. The cell below it will have this formula: =SUM($G$3*E15) I hope that helps, not very good at explaining =) Do a search on references and read up on the difference between relative and absolute references -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=550431 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does the $ mean when used in a formula please: $G or $3
The $ sign is used to change cell references from "relative" to absolute". This
fixes the reference so's it will not change as copied down or across. $A1 is absolute column and relative row. $A$1 is absolute column and row. A$1 is relative row and absolute column. Se help on relative and absolute cell references for more on this. Gord Dibben MS Excel MVP On Fri, 9 Jun 2006 11:28:01 -0700, bldurgin wrote: I am unable to find in search of Help files or Reference online. Here's the fomula: =SUM($G$3*E14) |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does the $ mean when used in a formula please: $G or $3
"bldurgin" wrote: I am unable to find in search of Help files or Reference online. Here's the fomula: =SUM($G$3*E14) Thank you one and all for you quick and most helpful replies. I could get nothing when trying to search for the $ in help and it was getting a bit frustrating |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |