Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Formulas
Resolved · High Priority · Version 2003
Reply Wed 14 Jan 2009, 16:37Delegate Claire said...
For upcoming training course dates see: Pricing & availability
RE: Formulas
Hello Claire
Thank you for your question and welcome to the forum.
The $ sign is used in a formula when you want to be able to fix or lock a particular cell reference into a formula (known as an absolute reference).
For example, if you wanted to be able to multiply different figures by the same value, you could enter the value you are multiplying by into a cell.
Then when you put the formula together to do the multiplication, you use $ signs in front of the column letter and in between the column letter and row number of the cell to fix or lock this cell into the formula. E.g. $A$2
I hope this helps.
Amanda
Wed 21 Jan 2009: Automatically marked as resolved.
|