Forum Discussion
Joyce UGEN
Oct 04, 2017Copper Contributor
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
Sort By
- Alun DaviesCopper Contributor
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.
- Detlef_LewinBronze Contributor
Joyce,
that should have been a topic in your beginners course.