microsoft+excel+training+london - formulas using symbol

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

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

resolvedResolved · Low Priority · Version Standard

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

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 tip:

Page Break Preview in Excel 2010 (Hint/tip)

If you select View then Workbook Views then Page Break Preview, you will be able to view how your Excel spreadsheet will be split across multiple pages when printed. Even better, you can also drag a page break to a new place. Excel will then scale down your entire worksheet to fit the information you want on the pages you want.

View all Excel hints and tips


Server loaded in 0.1 secs.