=IF(AVERAGE(IF(ISERROR(A1*(AVERAGE(A2,A3))),0,A1*(AVERAGE(A2,A3))),IF(ISERROR(B1*(AVERAGE(B2,B3))),0,B1*(AVERAGE(B2,B3))),IF(ISERROR(C1*(AVERAGE(C2,C3))),0,C1*(AVERAGE(C2,C3)))) >=30,"合格","不合格")