If columns BE thru BI are all "Pass", then return status of "Pass" (All 5 columns need to have Pass), If any columns BE the BI contain "Q", then return "Retest" (If even one column has an Q, then it needs to be "Retest, unless one of the 5 columns had a Fail), If Fail appears in any of those columns, then return "Fail" - (Fail always overrules a Q or Pass)
Solved by E. H. in 19 mins