excel中,如果A1B1C1均为合格则D1合格,如有一个不合格,则D1不合格?_百...答:在D1中输入或复制粘贴下列公式下列公式之一 =IF(AND(A1="合格",B1="合格",C1="合格"),"合格","不合格")=IF(COUNTIF(A1:C1,"不合格")>0,"不合格","合格")=IF(COUNTIF(A1:C1,"不合格"),"不合格","合格")=IF(COUNTIF(A1:C1,"不合格")=0,"合格","不合格")=IF(COUNTIF(A1:...
a1b1a2...这些等边三角形都在y等于x分之根号3上答:设五个等边三角形的边长分别为2a1,2a2,2a3,2a4,2a5 由于对应的五个高即 y1=√3a1, y2=√3a2, y3=√3a3, y4=√3a4, y5= √3a5 结合x1y1=x2y2=x3y3=x4y4=x5y5=2√3 得 a1=√2,a2=2-√2, a3=√6-2,a4=2√2-√6, a5=√10-2√2 { 注规律是 an=√(2n)-√(2n...