2006-10-15 10:34:15 · 2 answers · asked by blablablabla 2 in Computers & Internet ➔ Other - Computers
Okay this is applicable with formulas. Lets say you have a simple formula in A3 that is =A1+A2. If you copy the formula from A3 to B3, the formula will change to =B1+B2. It is called relative because the formula is relative to what cell it is located in. In the above the formula is basically the cell above plus the cell above that. An absolute reference is different, it means that no matter where you put the formula, it will use the same cells. This is typed $A$1+$A$2. In this case, no matter where you move the formula, it will add A1 and A2. If you need any further help, email me.
2006-10-15 11:02:45 · answer #1 · answered by mysticman44 7 · 0⤊ 0⤋
Relative references:
Means that if you call a cell A1 while you are in D1, then when you "COPY" this cell to D2, its references will change automatically to A2.
Notice we copied the cell D1 to D2 (One cell down), so the A1 in D1 formula will change to A2 (One cell down)
And when you copy the cell from D1 to E1 (One cell to right), the A1 in D1 will be changed to B1 in E1 (One cell to right)
So the ref is related to its cell place
Absolute ref:
Is where you type $A$1 so copying the D1 cell to D2 or E1 will not make $A$1 be changed.
mail me for more info
Read my profile, I am the XLMan
2006-10-16 06:18:36 · answer #2 · answered by Anonymous · 0⤊ 0⤋