If Function

The UK's most regular instructor-led training courses.
Training information: learn excel in london · Excel training course · 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:25) Reply

Why is this useful

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course				List price £245
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 May 20 Tue	Bloomsbury	7	book now	£218	£240
2003/XP	2008 May 21 Wed	Southwark	5	book now	£219	£235
2003/XP	2008 May 21 Wed	Bayswater	6	book now	£195	£205
2003/XP	2008 May 23 Fri	Bloomsbury	6	book now	£214	£230
2003/XP	2008 May 30 Fri	Southwark	6	book now	£214	£230
2003/XP	2008 Jun 4 Wed	Bayswater	7	book now	£203	£230
Full Schedule: See all 153 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: If Function

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

Hi Katy, I guess this is you again, in answer to the 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.

· Tools From Advanced Excel Courses: Goal Seek and Solver
· Microsoft Excel Courses Teach Advanced Macro Techniques
· MS Excel: Excel At Making The Most Of Your Christmas
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Basic Excel Training

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

Excel tip:

Hiding Formulae in the Formula Bar

It is possible to protect the contents of a cell reference(s) from amendment by applying cell protection. The contents of the cell reference can also be stopped from displaying in the formula bar.

Step 1: Select Format > Cells > Protection.

Step 2: Tick Hidden option. Ensure Locked is ticked

Step 3: Select Tools > Protection > Protect Sheet

(Ensure "Protect worksheet and contents of locked cells" is ticked)

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:

Hiding Formulae in the Formula Bar