MATCH and INDEX function instead NESTED IF function

Try this in H8 and drag down.

HTML Code: 

I am not sure about your logic for "Not Pass" vs "Fail". Aren't they the same?

If modytrane's logic is correct, then I might use something like =INDEX($A$1:$A$5,MATCH(MIN(E8:G8),$B$1:$B$5,1)). Pay careful attention to the behavior of the MATCH() function with 1 as the match_type argument https://support.office.com/en-us/art...9-533f4a37673a because the values in column B will need to be in ascending order -- which means that the not pass/fail entries will need to be above the others, with a suitable value for each entry.

Maybe this???