The USE of the Dollar $ sign in Excel calculation. How does it work? what are the benefit and rules

[Joyce UGEN]

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]

Joyce,

that should have been a topic in your beginners course.

[#3]

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.