Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
What does the $ do in excel formulas?
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
What does the $ do in excel formulas?
Suppose you have in B1, the formula =2*A1
Now you copy this to D3 and you get =2*C3 Excel has changed the cell reference because it was treated as 'relative' - A1 is on the left of B1 on the same row so when we copy the formula A1 gets changes to one to the left and on the same row as the new formula. If you had (in B1) =2*$A1 and copied to D3 you would get =2*$A3 because now the column (A) is 'absolute' by virtue of the $ and does not get changed. Likewise if B1 has =2*A$1 and this is copied to D3 we get =2*C$1 Finally =2*$A$1 in B1 copied to D3 gives =2*$A$1 best wishes BTW: please write your question in the white space and not just in the subject line -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "joymina" wrote in message ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel considers my formulas as plain text | Excel Worksheet Functions | |||
How do you print showing formulas in Excel 2000? | Excel Discussion (Misc queries) | |||
Please help with Statistics Formulas in Excel | Excel Discussion (Misc queries) | |||
Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) |