Formulas

The UK's most regular instructor-led training courses.
Training information: best training excel vba · Excel advanced · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Formulas

Jonathan has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Jonathan [1 post] (2008 Feb 20 Wed, 16:01) Reply

What is the purpose of IF statements?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Jan 8 Thu	Bloomsbury	2	book now	£215	£215
2007	2009 Jan 8 Thu	Bloomsbury	3	book now	£224	£224
2007	2009 Jan 12 Mon	Bayswater	4	book now	£224	£224
2007	2009 Jan 13 Tue	Bloomsbury	2	book now	£224	£224
2002/XP	2009 Jan 13 Tue	Tooting	0	FULL
2003	2009 Jan 15 Thu	Southwark	1	book now	£215	£215
Full Schedule: See all 136 Excel Intermediate course dates. Bookings currently available until 30th March 2010.

RE: Formulas

by - trainer Rich platinum contributer [754 posts] (2008 Feb 23 Sat, 22:47) Reply

Say you have a list of data for a sales department. If the value of the sale was 1-15 then you want the value in the column to say 'Small Sale', value is 16-30 then 'medium sale', value is >31 then 'large sale' then this could be achieved by using an if statement. One example of many.

· Identifying Suitable Candidates For VBA For Excel Training
· Tap the Power of Recorded Macros with MS Excel Courses
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Microsoft Excel Training - Discover A Hidden Power At Your Fingertips
· Microsoft Excel Training: Not Just for Newbies Anymore

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