formulas

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas

Formulas

resolvedResolved · 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


 

Excel tip:

Outlining - ungrouping rows or columns

Highlight want you want to ungroup and press ALT + SHIFT + right cursor arrow

View all Excel hints and tips


Server loaded in 0.08 secs.