A
applesarah
What does the $ in front of a letter or number mean ?
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.
P
PCLIVE
It maintains the column and row references in the case where the cell is
copied and pasted in another column or row.
Example. If this formula was in A1 and you copied it to B2, the formula
would automatically change to:
=Sum-($C$22:F23)
Notice that cell C22 did not change, but E22 changed to F23.
HTH,
Paul
copied and pasted in another column or row.
Example. If this formula was in A1 and you copied it to B2, the formula
would automatically change to:
=Sum-($C$22:F23)
Notice that cell C22 did not change, but E22 changed to F23.
HTH,
Paul
R
Rick Rothstein \(MVP - VB\)
What does the $ in front of a letter or number mean ?
See if this helps you...
http://www.cpearson.com/excel/relative.aspx
Rick
See if this helps you...
http://www.cpearson.com/excel/relative.aspx
Rick
R
Ron Coderre
The dollar sign ($) is a flag to Excel to "lock" that
part of the reference when copy/pasting the cell.
Examples:
A1: =B1
Copy A1 and paste in C2.
The formula in C1 is: =D2
A1: =$B1
Copy A1 and paste in C2.
The formula in C1 is: =$B2
A1: =B$1
Copy A1 and paste in C2.
The formula in C1 is: =D$1
A1: =$B$1
Copy A1 and paste in C2.
The formula in C1 is: =$B$1
For more information, search Excel Help for "range references"
and see the "about cell and range references" section
and select the "The difference between relative and absolute references"
topic
Does that help?
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
part of the reference when copy/pasting the cell.
Examples:
A1: =B1
Copy A1 and paste in C2.
The formula in C1 is: =D2
A1: =$B1
Copy A1 and paste in C2.
The formula in C1 is: =$B2
A1: =B$1
Copy A1 and paste in C2.
The formula in C1 is: =D$1
A1: =$B$1
Copy A1 and paste in C2.
The formula in C1 is: =$B$1
For more information, search Excel Help for "range references"
and see the "about cell and range references" section
and select the "The difference between relative and absolute references"
topic
Does that help?
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
R
Ron Coderre
Of course, my post was rife with typos. : \
All references to "C1" should be "C2".
My apologies.
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
All references to "C1" should be "C2".
My apologies.
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
T
Tyro
The $ means that the reference is absolute. For example $A$1 refers to cell
A1. You can copy that reference anywhere and it will refer to A1. If you use
A1, a relative reference, instead of $A$1, and you copy that it will change
to be relative to the cell into which you have copied it. For example if in
cell B1 you have the formula =$A$1 and copy that to cell B2 you will have
the formula =$A$1 in B2. If in B1 you have the formula =A1 and copy that to
cell B2 you will have the formula =A2 in B2. Relative references change,
absolute references do not. You can make the column and/or row absolute or
relative as in A1, $A1, A$1, $A$1
I suggest you acquire a book on Excel by an author such as John Walkenbach
to get a basic understanding of Excel.
Tyro
A1. You can copy that reference anywhere and it will refer to A1. If you use
A1, a relative reference, instead of $A$1, and you copy that it will change
to be relative to the cell into which you have copied it. For example if in
cell B1 you have the formula =$A$1 and copy that to cell B2 you will have
the formula =$A$1 in B2. If in B1 you have the formula =A1 and copy that to
cell B2 you will have the formula =A2 in B2. Relative references change,
absolute references do not. You can make the column and/or row absolute or
relative as in A1, $A1, A$1, $A$1
I suggest you acquire a book on Excel by an author such as John Walkenbach
to get a basic understanding of Excel.
Tyro
D
David Biddulph
It applies absolute, rather than relative addressing (see Excel help, and
other answers here).
As a matter of interest, what is the minus sign after Sum in your formula
trying to do? In my Excel 2003 I get a #NAME? error from your formula. If
the minus sign is a typographical error, I would recommend that you don't
try to retype formulae between the newsgroup and your spreadsheet; instead
use copy and paste to and from your spreadsheet's formula bar.
other answers here).
As a matter of interest, what is the minus sign after Sum in your formula
trying to do? In my Excel 2003 I get a #NAME? error from your formula. If
the minus sign is a typographical error, I would recommend that you don't
try to retype formulae between the newsgroup and your spreadsheet; instead
use copy and paste to and from your spreadsheet's formula bar.