Multiple IFs to display one result based on multiple criteria

Hi Experts!

Long time since I begged for help on this forum, glad to be back

I've got a matrix combining actions on the left hand side (Col A) and owners on Cols B to F
I have drop down list for each action/owner combo: N/A, OK, KO, TBD.

	Owner #1	Owner #2	Owner #3	Owner #4	Owner #5	Results
Action #1	OK	TBD	N/A	N/A	N/A	OK
Action #2	TBD	OK	OK	KO	TBD	KO
Action #3

I would like to create a formula in Col G that does the following:

• If any of the values in columns B to F equals OK, then OK

• If any of the values in columns B to F equals KO, then KO

I've been tinkering with multiple IFs and quite rightly got bogged down as too many criteria to take into account...

Thanks in advance for your help and advice!

I think this works:

Formula:

Please Login or Register  to view this content.