Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft+excel+training+london - Formula's using the $ symbol

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

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

Resolved · Low Priority · Version Standard

Reply Fri 26 Oct 2007, 13:01Delegate John said...

John has attended:
Excel Advanced course

Formula's using the $ symbol

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

For upcoming training course dates see: Pricing & availability

Reply Fri 26 Oct 2007, 16:02Delegate Paul said...

RE: Formula's using the $ symbol

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

Excel articles

· Excel Offers A More Relaxing Way To Work Out
· Reporting and Analysis with Excel
· Why do we even need XML anyway?
· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· How To Get The Best Out Of Excel With The Internet

Excel tip:

Hide separate columns in Excel 2010

If you want to hide columns not adjacent to each other for example, Columns A, C and E then:-

1) Click on the fist column to be hidden i.e. A

2) Press and hold down the CTRL key

3) While holding the CTRL key, left click on the rest of the columns you want to hide i.e. C and E

4) Right click and choose Hide

View all Excel hints and tips