microsoft+excel+training+london - Formula's using the $ symbol

The UK's most regular instructor-led training courses.
Training information: microsoft+excel+training+london · Excel course · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Formula's using the $ symbol

John has attended:
Excel Advanced course

by - delegate John [2 posts] (2007 Oct 26 Fri, 13:01) Reply

Hi,

Please could you tell me what the $ symbol does to a formula and what effect it's placement has on a formula?

Many thanks.
John

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	4	book now	£485	£490
2003	2009 Jan 22 Thu + 23 Fri	Southwark	0	FULL
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	4	book now	£475	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	5	book now	£485	£490
2003	2009 Feb 19 Thu + 20 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 26 Thu + 27 Fri	Bayswater	8	book now	£335	£365
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 18th March 2010.

RE: Formula's using the $ symbol

by - delegate Paul gold contributer [121 posts] (2007 Oct 26 Fri, 16:02) Reply

the $ sign is used for when you want to 'drag out' a formula over many many cells, but keep the cell reference in the formula the same.
For instance, you have a figure in cell C1 that is a 'target' for salespeople to hit and you have a list of all the salespeople's actual scores in column A

type the following formula in cell B1 to keep referencing C1:

=$C$1-A1 and drag the formula down column B

Hope this helps

Paul

· MS Excel: Excel At Making The Most Of Your Christmas
· Microsoft Office and the Small Business: Part 1 Excel
· Identifying Suitable Candidates For VBA For Excel Training
· Do You Really Need Excel VBA Training?
· Why Should I Learn Visual Basic in Excel?