excel word powerpoint courses london - nested if

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 word powerpoint courses london - Nested if

excel word powerpoint courses london - Nested if

resolvedResolved · Low Priority · Version 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:

Display developer tab - Excel 2010

a. In Excel, click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the box next to Developer in the list of tabs on the right hand side of the dialog box. When ticked the Developer tab will be visible.
e. Click OK to apply your changes

View all Excel hints and tips


Server loaded in 0.08 secs.