If Function

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

Resolved · Low Priority · Version 2003

If Function

Katy has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Katy [3 posts] (2008 Apr 30 Wed, 16:23) Reply

Why is this useful

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course				List price £495
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 May 22 Thu + 23 Fri	Southwark	5	book now	£450	£485
2003/XP	2008 Jun 5 Thu + 6 Fri	Bayswater	6	book now	£450	£485
2003/XP	2008 Jun 12 Thu + 13 Fri	Bloomsbury	6	book now	£450	£485
2003/XP	2008 Jun 19 Thu + 20 Fri	Southwark	5	book now	£450	£485
2003/XP	2008 Jul 3 Thu + 4 Fri	Southwark	6	book now	£450	£485
2003/XP	2008 Jul 17 Thu + 18 Fri	Bloomsbury	5	book now	£450	£485
Full Schedule: See all 65 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: If Function

by - trainer Pete platinum contributer [571 posts] (2008 May 6 Tue, 09:42) Reply

Hi Katy, Thank you for your post, In answer to your question, the IF function is used to determine the state of a condition, ie: if it is TRUE or FALSE, dependant on the answer then further actions can be undertaken; so if we condsider the formula =IF(A1>=100,A1*2,0) which translated would be; Is A1 greater than or equal to 100, if it is (TRUE) then multiply the value of A1 bt 2, if it is not, (FALSE) then do nothing (0).
Taking this further, you can nest up to 7 IF statements, and also use other formula in the IF statement, substituted for either of the statements (TRUE or FALSE).
I hope that has helped a bit, if so please click the resolved link, best regards Pete.

· Microsoft Excel Training Course
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· Crazy Things People Have Done With Excel
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Customized Financial Excel Courses in London

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

Excel tip:

Fill formulae across a sheet

To copy a formula down a spreadsheet where there is data underneath, to the left or to the right of the formula, double-click on the fill handle. The fill handle is the little black cross that appears in the bottom right-hand corner of the formula cell. Unfortunately, no similar facility exists to copy formulae across the sheet.

One reasonably quick way to copy an existing formula across a sheet is to select the formula and the cells on the right to which you want to copy it. Then press Ctrl+R to copy the formula across the selected range, or, if you are menu-minded, use the Edit|Fill|Right command.

View all Excel hints and tips

Institute of IT Training - Accredited Training Provider

secure online payments - visa - mastercard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Training by application

Main information pages

If Function

Related articles

Excel tip:

Fill formulae across a sheet