Alternative to using multiple nested IF statements

That works great. Just one more question. In other cases, there may be more than one possibility of key words for the grade. For example say the key words are "Fail" and "Pending". The formula also works for this scenario.

=IF(OR(COUNTIF(A2:H2,"Fail"),COUNTIF(A2:H2,"Pending"))>0,"Review","Ok")

My question is what if I had 15 words that I needed to key in on? Instead of having 15 different COUNTIF sections in the formula, is there a more effecient way to write the formula that what I have presented (i.e. could I create a list of key words and reference the list in the formula).

Thanks again.

Much easier than the other way. I had to tweak your formula from:

=IF(COUNTIF(A2:H2,"Pass")=COUNTA(A2:H2)/2,"Ok","Review")

to:

=IF(COUNTIF(A2:H2,"Pass")=COUNTA(A2:H2),"Ok","Review")

Thanks again.

You are correct. I was testing without take that variable into account. Thanks for pointing that out.