怎么样用excel公式来判断单元格对或错或半对半错?如何自动计算得分...答:在C2输入公式:=IF(B2="","",IF(COUNT(1*FIND(MID(LOWER(B2),ROW(INDIRECT("1:"&LEN(B2))),1),LOWER(E2)))=LEN(B2),IF(LEN(B2)=LEN(E2),"√","tf"),"×"))公式以CTRL+SHIFT+ENTER三键结束。将公式向下复制。在D2输入公式:=IF(B2="","",IF(C2="×",,IF(C2="√",2...