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

excel+training - formulas

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+training - Formula's

excel+training - Formula's

ResolvedVersion Standard

Mandy has attended:
Excel Introduction course

Formula's

What does the dollar sign mean.

RE: Formula's

Hi Mandy,

The dollar sign represents an absolute fixed column, row or cell.

If you copy or fill formulas to other cells, Excel usually updates them to match the appropriate Row or Column.

For example, if I enter the formula =sum(A1+A2) in cell A3, and then copy and paste that formula into cell B3, Excel will assume I want the formula changed to =sum(B1+B2).

However, if I enter =sum($A$1+$A$2) and copy/paste to B3, it won't change an element with dollar sign in front, and keep the formula the same.

It's also handy if you have a cell with a very specific value (eg. current exchange rate for GBP to USD). Say you have it in cell A1. At least you know that throughout your document, you can put $A$1 and it will ALWAYS reference that cell, no matter where you move your formula.

When editing a cell, you can press F4 to toggle between the variations of the relative, absolute and mixed styles of referencing.

Excel Help describes the difference between the two as:

- Absolute cell reference: In a formula, the exact address of a cell, regardless of the position of the cell that contains the formula. An absolute cell reference takes the form $A$1.

- Relative reference: In a formula, the address of a cell based on the relative position of the cell that contains the formula and the cell referred to. If you copy the formula, the reference automatically adjusts. A relative reference takes the form A1.

Hope this helps.

Regards, Rich

Excel tip:

Creating charts in Excel 2010

Here's how to present your data in a chart format:

Highlight the data you wish to use in a chart

Click the Insert Ribbon

In the Charts Group, select Column Chart

Your chart will then appear on your work sheet.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.