Formula
if [m1, m2, m3, m4, m5].flat().includes "Yes" "Yes" else if [m1, m2, m3, m4, m5].flat().every((v) => v == "Unknown") "Unknown" else "No"
Walk Free
m2
2019
Walk Free
m3
2019
Walk Free
m4
2019
if [m1, m2, m3, m4, m5].flat().includes "Yes" "Yes" else if [m1, m2, m3, m4, m5].flat().every((v) => v == "Unknown") "Unknown" else "No"