98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas
Formulas
Resolved · Low Priority · Version Standard
Rebecca has attended:
Excel Intermediate course
PowerPoint Introduction course
Formulas
When do i use a $ in a formula? - What does it mean?
RE: Formulas
Hi Rebeeca
Hope you enjoyed the training course yesterday?
In relation to your question about dollar signs, then reason for using them is so that you can tell excel, that you want to keep a cell reference permanent or semi permanent and to insert the dollar signs you can either type in the signs or use the F4 button on your keyboard, when you use them is when you have typed the reference you want to use
Hope this helps you
Mark East
RE: Formulas
Hi Mark,
Thanks for the answer.
I enjoyed the training and think i am to be booked on to the advanced one at some point.
Thanks Again,
Rebecca
RE: Formulas
Hi Rebecca
Thanks for your quick response it great to hear from you again, if you have any other question please feel free to post them or just reply to this one again i am glad to help
If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn
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. |
Excel tip:Outlining - ungrouping rows or columnsHighlight want you want to ungroup and press ALT + SHIFT + right cursor arrow |