Hi,

I am am new user and am need of some assistance in regards to the above.
Sometimes in cell formulas there are $ signs, and other times not. What is
the difference?

Any help would be greatly appreciated.
tx

http://www.cpearson.com/excel/relative.aspx
http://www.mrexcel.com/tip048.shtml


Regards,
Ryan--

PS, Google is your friend...
--
RyGuy


"Heather" wrote:

Hi,

I am am new user and am need of some assistance in regards to the above.
Sometimes in cell formulas there are $ signs, and other times not. What is
the difference?

Any help would be greatly appreciated.
tx

Relative

=A1 is relative, if you drag the formula right the A will increment to =B2
etc and if you drag down the 1 becomes 2

=$A1 is column absolute so if you drag right the column stays the same but
if you drag down +A1 becomes =A2

=$a$1 is absolute and dragging in either direction will not increase the
column or row.

Mike

"Heather" wrote:

Hi,

I am am new user and am need of some assistance in regards to the above.
Sometimes in cell formulas there are $ signs, and other times not. What is
the difference?

Any help would be greatly appreciated.
tx

Help explains quite nicely what the $ signs mean and when to use them.

Type "cell references" into the Help box.


Gord Dibben MS Excel MVP

On Thu, 1 May 2008 11:46:00 -0700, Heather
wrote:

Hi,

I am am new user and am need of some assistance in regards to the above.
Sometimes in cell formulas there are $ signs, and other times not. What is
the difference?

Any help would be greatly appreciated.
tx