Hi John, Bob, Mike and Jon,

Thank you all for explaining that to me - it makes perfect sense now!

Antonia

"Jon" wrote:

It locks the cells in the formula. For example, if you copy/drag that
function down one cell, it will lock to cell F3 due to the $ signs, while Q29
will change to Q30.

jon

"Antonia" wrote:

Hi,

I wondered if someone could explain what the $ sign means in a formula.
I've inherited a spreadsheet with lots of them appearing all over the place
but I can't work out how to break down the formule; here's an example:

=IF(N29=$F$3,Q29,0)

Many thanks,