B
bldurgin
I am unable to find in search of Help files or Reference online. Here's the
fomula:
=SUM($G$3*E14)
fomula:
=SUM($G$3*E14)
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
RJ
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).
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).
P
Peo Sjoblom
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
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
T
T Kirtley
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. .
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. .
R
RJ
If you want further explanations, Microsoft Excel's help file has a specifiec
section devoted to the difference between relative and absolute references.
section devoted to the difference between relative and absolute references.
B
Bearacade
bldurgin said:I am unable to find in search of Help files or Reference online. Here'
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 referenc
and E14 is not. So if you fill drag this formula down. The cell belo
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 betwee
relative and absolute reference
G
Gord Dibben
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
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
B
bldurgin
Thank you one and all for you quick and most helpful replies. I could getbldurgin said:I am unable to find in search of Help files or Reference online. Here's the
fomula:
=SUM($G$3*E14)
nothing when trying to search for the $ in help and it was getting a bit
frustrating