Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Please can someone explain in laymans terms why the $ symbol before a cell
reference in a formula makes a difference. Thanking you in anticipation. -- Big Rick |
#2
![]() |
|||
|
|||
![]()
It will create an absolute reference. Let's say you have a cell reference
pointing to A1... If you drag that down to the next cell the reference will change to A2. However, if you put dollar signs around the reference (i.e. A$1) and drag down it will still reference A1. -- Regards, Dave <!-- "Big Rick" wrote: Please can someone explain in laymans terms why the $ symbol before a cell reference in a formula makes a difference. Thanking you in anticipation. -- Big Rick |
#3
![]() |
|||
|
|||
![]()
I'll try <g
When you copy a formula from one cell to another, if there is no $, Excel updates any cell references in that formula relative to its destination cell. So, If A1 has the formula =IF(B17,C1,D1) and you copy that to B7, the formula that ends up un B7 is =IF(C77,D7,E7) Notice the columns have shunted acros 1, the rows down 6. If the formula were =IF($B$17, $C$1,$D$1), the formula that ends up in B7 would be exactly the same. Sometimes you want absolut ($$), sometimes relative, sometimes a mix. -- HTH Bob Phillips "Big Rick" wrote in message ... Please can someone explain in laymans terms why the $ symbol before a cell reference in a formula makes a difference. Thanking you in anticipation. -- Big Rick |
#4
![]() |
|||
|
|||
![]()
Many thanks for you quick responce.
-- Big Rick "David Billigmeier" wrote: It will create an absolute reference. Let's say you have a cell reference pointing to A1... If you drag that down to the next cell the reference will change to A2. However, if you put dollar signs around the reference (i.e. A$1) and drag down it will still reference A1. -- Regards, Dave <!-- "Big Rick" wrote: Please can someone explain in laymans terms why the $ symbol before a cell reference in a formula makes a difference. Thanking you in anticipation. -- Big Rick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
€ (euro) symbol in Excel charts | Charts and Charting in Excel | |||
The Mathematical "Implies" symbol | Excel Discussion (Misc queries) | |||
how to find and replace a symbol in my worksheet | Excel Discussion (Misc queries) | |||
I need a symbol but "symbol" in the Insert menu is grayed-out. | Excel Discussion (Misc queries) | |||
Diamond Symbol | Excel Discussion (Misc queries) |