View Single Post
  #5   Report Post  
Old March 22nd 10, 09:31 PM posted to microsoft.public.excel.newusers
Russell Dawson[_2_] Russell Dawson[_2_] is offline
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2010
Posts: 181
Default Functions for dummies

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?