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

microsoft excel training - if statement

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training - If statement

microsoft excel training - If statement

ResolvedVersion Standard

Dominique has attended:
Excel Intermediate course
Excel Advanced course

If statement

How do I do nested if statements?

RE: If statement

Hi Dominique,

nested if statements are quite useful at times. you can only nest a maximum of 7 ifs together but it's done a bit like this.

=if(A1=1,"A",if(A1=2,"B",if(A1=3,"C")))

note that you are to put one close bracket for every open bracket.

hope this helps

Paul

Excel tip:

Printing spreadsheets without opening them first

Here's a fast way of printing a spreadsheet from Windows Explorer/My Computer.

Go to the location where the spreadsheet is saved on your computer, then right-click on the icon next to the document and select Print from the menu.

The spreadsheet will automatically open, print and close itself.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.