excel 2003 visual basic intermediate course - Nested IF function

The UK's most regular instructor-led training courses.
Training information: excel 2003 visual basic intermediate course · Excel course london · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Nested IF function

Khalid has attended:
Excel Advanced course

by - delegate Khalid [1 post] (2008 Jan 24 Thu, 14:02) Reply

How do you perform nested IF functions using the formula wizard? Is it always done via memorable means?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	4	book now	£207	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Nested IF function using Formula Wizard

by - trainer Katie gold contributer [214 posts] (2008 Feb 6 Wed, 15:11) Reply

Hi Khalid,

"Nested IFs" is used when you need to catergorise a list of data. Let's say there are 4 categories then you will need 3 if statements.

1) Use the Formula Wizard to set up the 1st IF
2) Type in the test & true values, click on the FALSE box, then click on the "IF" button on formula bar (where name box usually sits)
3) It opens another IF dialogue box for your 2nd IF statement, repeat step 2 at the FALSE box.
4) Type in the 3rd set of test & true statements
5) At the final FALSE statement, type in the 4th category.
6) Press OK

See if this helps

Regards,

Katie Woo
Microsoft Certifie Trainer

· Database Tips from an Excel Training Course
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Tips to Facilitate Printing of Excel worksheets
· What's Better Than the Help Function in Excel? Microsoft Training
· Tips for Transitioning to Excel 2007

Excel tip:

Deleting a range of cells using the autofill handle

Firstly, select the range of cells for which you would like to clear the contents. Then drag the autofill handle to the the top left corner of the selection whilst holding down the shift key. Your selected contents should then be deleted.

View all Excel hints and tips