IF Formula Involving Non-adjacent Cells Forming Array With Four Conditions

[Zedrick13]

Hi everyone,

I hope you can help me with my concern. This formula,

=IF(ISERROR(MATCH("Fail",CHOOSE({1;2;3;4;5;6},Q57,S57,U57,W57,Y57,AA57),0)>0),IF(ISERROR(MATCH("Pass",CHOOSE({1;2;3;4;5;6},Q57,S57,U57,W57,Y57,AA57),0)>0),"Unexecuted","Pass"),"Fail")

worked perfectly to address the conditions below:

1. If columns Q;S;U;W;Y;AA have at least 1 Fail, value for column O must be "Fail".
2. If columns Q;S;U;W;Y;AA are a mix of Pass and blanks only, it's a "Pass" for column O.
3. If columns Q;S;U;W;Y;AA are all blank, column O returns value "Unexecuted".

However, I needed to make a little bit of change to condition # 2 below and add another one. But, however I try to, I can't come up with the correct formula. So, here are the conditions that need to be met for the formula that I need:

1. If columns Q;S;U;W;Y;AA have at least 1 Fail, value for column O must be "Fail".
2. If columns Q;S;U;W;Y;AA are a mix of Pass and blanks only, it's a "WIP" for column O.
3. If columns Q;S;U;W;Y;AA are all blank, column O returns value "Unexecuted".
4. If columns Q;S;U;W;Y;AA are all Pass, column O should show "Pass".

I really hope you can help me...

Thanks.

 

[Zedrick13]

I apologize to the moderator and everyone here. This is a duplicate post. You may take this down. Or, is there a way for me to delete this?