For some applications youll need the $ symbol. For example if im verifying multiple forecast values against a single observation in A1, I need to maintain the reference to A1 in the formulas since excel will automatically change your formula to A2, A3, A4....when copied.