Formula
m7 = "Yes" if ["Already Achieved", "By 2020", "By 2030", "By 2040", "By 2050", "After 2050"].includes m7 m8 = "Yes" if ["Core Partner", "Participant"].includes m8 if [m1, m2, m3, m4, m5, m6, m7, m8].includes "Yes" "Yes" else "No"
m7 = "Yes" if ["Already Achieved", "By 2020", "By 2030", "By 2040", "By 2050", "After 2050"].includes m7 m8 = "Yes" if ["Core Partner", "Participant"].includes m8 if [m1, m2, m3, m4, m5, m6, m7, m8].includes "Yes" "Yes" else "No"