Formulas

Hello Claire

Thank you for your question and welcome to the forum.

The $ sign is used in a formula when you want to be able to fix or lock a particular cell reference into a formula (known as an absolute reference).

For example, if you wanted to be able to multiply different figures by the same value, you could enter the value you are multiplying by into a cell.

Then when you put the formula together to do the multiplication, you use $ signs in front of the column letter and in between the column letter and row number of the cell to fix or lock this cell into the formula. E.g. $A$2

I hope this helps.
Amanda