Go into your xl help, and search on the absolute and relative references.
--
John C


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