Forum Discussion
Formula in Excel
- Jun 20, 2020
mtarler Thank you so much that worked perfectly.
juliedenman Hi there. One of the most important things you can learn as you start to use Excel formulas is the use of the $ symbol. This $ symbol can be used in a cell reference in front for the column or the row or both and will LOCK it so it will not change during a fill or copy operation. So in your example the formula should be written as:
=SUM(B4*$C$1)
Technically since you are only filling or copying down in the same column you could use "C$1" since the relative location of the column won't change and the $1 will lock it at row 1. But for a fixed cell location like that I recommend using the $C$1 so if later you decide to make a copy of that cell/formula to another column to modify the calculation, it will still point to that correct cell.
Best of Luck.
mtarler Thank you so much that worked perfectly.