I have an if statement that is working correctly, however when I attempt to have the results alternate to FAIL when all FAILS are selected in the range I am missing something in my formula. What have I forgotten to add? =IF(OR(ISBLANK(F2),ISBLANK(F3),ISBLANK(F4),ISBLANK(F5),ISBLANK(F6),ISBLANK(F7)*ISBLANK(F8)*ISBLANK(F9)*ISBLANK(F10)),"",IF(AND(F2=F3,F3=F4,F4=F5,F5=F6,F6=F7,F7=F8,F8=F9,F9=F10),"Pass","Fail"))
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Help me with my IF statement
- Thread starter CMucha
- Start date
Scott Huish
MrExcel MVP
- Joined
- Mar 17, 2004
- Messages
- 20,711
- Office Version
- 365
- Platform
- Windows
Gonna simplify that a whole bunch:
=IF(COUNTA(F2:F10),IF(AND(F2<>"Fail",COUNTIF(F2:F10,F2)=9),"Pass","Fail"),"")
=IF(COUNTA(F2:F10),IF(AND(F2<>"Fail",COUNTIF(F2:F10,F2)=9),"Pass","Fail"),"")
Upvote
0
Solution
Upvote
0
