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

excel word powerpoint courses london - nested if

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel word powerpoint courses london - Nested if

excel word powerpoint courses london - Nested if

ResolvedVersion Standard

Theophile has attended:
Excel Advanced course
Access Intermediate course

Nested if

How many "IF" can there be in a formula?

RE: nested if

8 times. Try this

=IF(A1=B1,IF(A2=B2,IF(A3=B3,IF(A4=B4,IF(A5=B5,IF(A6=B6,IF(A7=B7,IF(A8=B8,"YES","NO")))))))))

pasted in cell C1

then just before the "before YES, try adding this: if(A9=B9,

this shouldn't work, because 8 is the max

Hope this helps

Paul

Excel tip:

Create Equations in Excel 2010

Here's how to create basic mathematical
equations in your Excel 2010 worksheet.

1) On the Ribbon, click the Insert tab
2) In the Symbols group, click the arrow next to Equation
3) Select from the equations and the equation will be inserted in a text box

Or you can create your own equation:

1) Insert and select the text box
2) On the Ribbon, click the Insert tab
3) In the Symbols group, click Equation
4) The Equation Tools Design Ribbon will now be displayed

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.09 secs.