excel 2003 visual basic intermediate course - nested if function

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel 2003 visual basic intermediate course - Nested IF function

excel 2003 visual basic intermediate course - Nested IF function

resolvedResolved · Low Priority · Version Standard

Khalid has attended:
Excel Advanced course

Nested IF function

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

RE: Nested IF function using Formula Wizard

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


 

Excel tip:

Creating charts in Excel 2010

Here's how to present your data in a chart format:

Highlight the data you wish to use in a chart

Click the Insert Ribbon

In the Charts Group, select Column Chart

Your chart will then appear on your work sheet.

View all Excel hints and tips


Server loaded in 0.08 secs.