Non-party member: enter =NOT(D 12= "party member") in J 12, and TURE is party member.

Pass both math AND Chinese: If only AND statements are allowed in K 12: = AND (f12 > =60，g 12 & gt； =60), pass will return TRUE, fail will return FALSE, and pass or fail if necessary: = if (and (f12 > =60，g 12 & gt； =60), "Pass", "Failure")

Math and English failed in one subject: = or (f 12

Calculate failing subjects with triple IF: = IF (and (f12 > =60，g 12 & gt； =60)，" 0 "，IF(AND(f 12 & lt； 60，g 12 & lt； 60), "2", if (or (f12 <; 60，g 12 & lt； 60)," 1")))

I don't know what your standard is, and what are the conditions for the first year of high school. Take the triple IF above as an example.