Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
$ definition
This may be a stupid question...;) however i would really appreciate if somebody could answer for me what the $ means in a formula...it has been causing me some problems, and a definition would really help me out. Thanks--nicole -- nicolebelle ------------------------------------------------------------------------ nicolebelle's Profile: http://www.excelforum.com/member.php...o&userid=28847 View this thread: http://www.excelforum.com/showthread...hreadid=486201 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
$ definition
This really comes into play when you copy a cell's formula. For instance,
assume that the cell C1 has the formula =A1+B1. If you copy C1 to C2, you will get the formula =A2+B2. This is fully relative referencing. However, if you use an absolute reference, you fix that part of the formula. For example, in C1 use =A$1+B$1, copy that to C2 and you get the same formula, namely =A$1+B$1. So the row has been fixed, and when you copy the formula, it does change as the target row changes. Similarly you can fix the column absolutely, although in this instance it is not relevant. It would be if you also changed the target column (from C2 to say G2). One final point. If you edit a cell's formula (F2), and in the formula bar select a reference, you can quickly toggle through al of the combinations using the F4 key -- HTH RP (remove nothere from the email address if mailing direct) "nicolebelle" wrote in message ... This may be a stupid question...;) however i would really appreciate if somebody could answer for me what the $ means in a formula...it has been causing me some problems, and a definition would really help me out. Thanks--nicole -- nicolebelle ------------------------------------------------------------------------ nicolebelle's Profile: http://www.excelforum.com/member.php...o&userid=28847 View this thread: http://www.excelforum.com/showthread...hreadid=486201 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dropdownlist- I want user to choose a # but can I add definition | Excel Discussion (Misc queries) | |||
End of data definition | Excel Discussion (Misc queries) | |||
Definition of a statistical function (CQC) in Excel | Excel Worksheet Functions | |||
The definition of.... | Excel Worksheet Functions | |||
Definition of integer constraint | New Users to Excel |