$ sign
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,
|