Hi,

It fixes that reference as 'absolute'. that means if you drag the formula a
reference with $ in front won't change.

The options are

A1 - column and row relative
$A1 - column absolute - row relative
A$1 - Column relative - row absolute
$A$1 - column and row absolute

Try dragging your formula down and note that $F$3 wont change.

Mike

"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,