Forum Discussion
The USE of the Dollar $ sign in Excel calculation. How does it work? what are the benefit and rules
I am trying to understand Exel formars in my wor sheet E.g $D$23 * $C12 . i am used to D23*C12 what is the difference and benedit and what are the rules to using the $ signs
2 Replies
I also recommend you do a Course, For an answer the $ do nothing in the formulas, however in excel you often copy a row down, when you do excel will increment the row number in any formula for you if you want this to happen leave it as D23*C12 and it will change it to D24*C13 however if you have $D$23 * $C12 it will put in $D$23 * $C13 ( note the 12 still went to 13 as it was not $ ) the $ before the letter does the same trick on Column fills.
Joyce,
that should have been a topic in your beginners course.
