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