What is the difference between relative and absolute cell referenc
 

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

What is the difference between relative and absolute cell referenc
 

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

What is the difference between relative and absolute cell referenc
 

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

What is the difference between relative and absolute cell referenc
 

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