As this is a learning opportunity don't forget that the absolute reference
does not have to be applied to both column and row references.

The examples given all quote e.g. $a$1

It is possible to have $a1 or a$1 depending upon your requirements.


--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"gamegirl" wrote:

What does the $ & ! mean in a formula?