Formulas

Resolved · Low Priority · Version Standard

Formulas

Rebecca has attended:
Excel Intermediate course
Powerpoint Introduction course

by - delegate Rebecca [2 posts] (2008 Feb 28 Thu, 16:52) Reply

When do i use a $ in a formula? - What does it mean?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Dec 8 Mon	Bayswater	2	book now	£224	£224
2007	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 9 Tue	Tooting	0	FULL
2003	2008 Dec 11 Thu	Southwark	7	book now	£188	£215
2007	2008 Dec 16 Tue	Bayswater	6	book now	£207	£215
2002/XP	2008 Dec 16 Tue	Tooting	0	FULL
Full Schedule: See all 108 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Formulas

by - trainer Mark gold contributer [287 posts] (2008 Feb 29 Fri, 11:13) Reply

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

by - delegate Rebecca [2 posts] (2008 Mar 6 Thu, 10:48) Reply

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

by - trainer Mark gold contributer [287 posts] (2008 Mar 6 Thu, 11:46) Reply

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’t and you need further clarification then please press the reply button and ask for further clarification with your specific question. In case you have a related question then please ask the question as a separate posting.

Best Regards

Mark East
mark

· Microsoft Excel Training Course
· Tools From Advanced Excel Courses: Goal Seek and Solver
· MS Excel: Excel At Making The Most Of Your Christmas
· Advanced level training: Microsoft Excel and the Web
· Excel Macros for the Non-Programmer

Please browse our web site to find out more about
excel microsoft training and other Microsoft training courses.

Excel tip:

Naming and Using Constants

Constants make calculations easier so worksheets are more easily understood. Constant values also need to be given relevant and memorably names. It is also easier to change the value of a constant.

For example:
Instead of entering 17.5% in each cell when you generate a VAT amount you could name a Constant "VAT" and assigning a "0.175" value to it. To do this:

From the 'Insert' menu select 'Name', then select 'Define'.

Enter the constant´s name as 'VAT' (no spaces allowed) in the 'Names in Workbook' line.

Enter the constant value of '0.175' in the 'Refers To' text box - making sure any other text has been deleted.

Click OK.

In Excel you may have cell 'B10' as containing an amount and in 'C10' you want to work out the VAT on the amount in 'B10'.

The formula would be

=B10*VAT

This formula will generate the amount of VAT only.