Formula
m2yes = ["Yes", "Partial"] m3yes = ["Yes, Tier 1 only", "Yes, Tier 1 & 2", "Yes, all suppliers"] if m1 > 0 || m2yes.includes(m2) || m3yes.includes(m3) "Yes" else "No"
m2yes = ["Yes", "Partial"] m3yes = ["Yes, Tier 1 only", "Yes, Tier 1 & 2", "Yes, all suppliers"] if m1 > 0 || m2yes.includes(m2) || m3yes.includes(m3) "Yes" else "No"