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

#### Zedrick13

##### Board Regular
Hi everyone,

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

Code:
``=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.

Last edited:

### Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
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?

Last edited:

Replies
4
Views
158
Replies
0
Views
116
Replies
7
Views
166
Replies
2
Views
236
Replies
12
Views
340

1,203,454
Messages
6,055,539
Members
444,794
Latest member
HSAL

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back