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

formulas

ResolvedVersion 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

Excel tip:

Recovering Unsaved Work in Excel 2010

Ever closed your Excel workbook in a hurry without saving your work beforehand? Here's how to get it back.

Choose File then Info, click Manage Versions and then Recover Unsaved Workbooks which will automatically find the spreadsheets that haven't been saved.

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.13 secs.