excel做选择题时自动判断对错,并显示正确答案?答:1. 假设F列没有标准答案,可以使用以下公式来判断选择题的正确与否,并显示正确答案:H2 = IF(CHAR(64 + MATCH(--LEFT(A2, FIND("+", A2) - 1) + --SUBSTITUTE(RIGHT(A2, LEN(A2) - FIND("+", A2)), "=", "")), B2:E2, "") = G2, "正确", "错误")2. 同样地,对于I...
excel做选择题时自动判断对错,并显示正确答案?答:假设F列没有标准答案 H2=IF(CHAR(64+MATCH(--LEFT(A2,FIND("+",A2)-1)+--SUBSTITUTE(RIGHT(A2,LEN(A2)-FIND("+",A2)),"=",""),B2:E2,))=G2,"正确","错误")I2=CHAR(64+MATCH(--LEFT(A2,FIND("+",A2)-1)+--SUBSTITUTE(RIGHT(A2,LEN(A2)-FIND("+",A2)),"=","")...
Excel如何判断多选题对错答:=IF(OR(ISERR(FIND(MID(C1,ROW(INDIRECT("1:"&LEN(C1))),1),$B$1))),0,IF(SUM(N(ISNUMBER(FIND(MID(C1,ROW(INDIRECT("1:"&LEN(C1))),1),$B$1)))=LEN($B$1),$A$1,$A$2))按ctrl+shift+enter输入。公式中C1为答案所在列,$B$1为正确答案所在单元格,如有问题请补充说明...