What is the affect of adding the symbol $ into a excel formula

's Computer Specifications

's Computer Specifications

Absolute reference.
--
David Biddulph

"wilson staff" <wilson (E-Mail Removed)> wrote in message
news:CA5CE8D7-FEE5-46A2-B8ED-(E-Mail Removed)...
>

's Computer Specifications

there are 2 forms of referencing in a formula. Absolute (indicated with a $
symbol) and relative (no symbol). When a relative referenced formula is
copied or dragged the column and/or row numbers will increment. Absolute
referenced cells will not. Hit F1 to bring up the hlep and type in Absolute
reference for further details...
--
HTH...

Jim Thomlinson

"David Biddulph" wrote:

> Absolute reference.
> --
> David Biddulph
>
> "wilson staff" <wilson (E-Mail Removed)> wrote in message
> news:CA5CE8D7-FEE5-46A2-B8ED-(E-Mail Removed)...
> >
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: Euro symbol displays as dollar symbol in Excel	Gord Dibben	Microsoft Excel Worksheet Functions	0	24th Apr 2009 03:43 PM
RE: Euro symbol displays as dollar symbol in Excel	Sheeloo	Microsoft Excel Worksheet Functions	3	24th Apr 2009 07:57 AM
What does the symbol <> mean in an Excel formula?	=?Utf-8?B?Z3JlZ29wb3dlcg==?=	Microsoft Excel Misc	1	22nd Sep 2006 07:05 PM
Does adding secondary hard drives affect XP activation?	ss6nn1@googlemail.com	Windows XP General	16	23rd Aug 2006 02:20 PM
Adding the Degree symbol in Fahrenheit to an excel spreedsheet.	Rick B	Microsoft Excel Worksheet Functions	8	11th Feb 2004 09:16 PM