假设在A1,B1单元格,A1是考生答案,B1标准答案
if(len(A2) > len(B2) || len(A2) = 0, 0, if(count(GREPARRAY(split(A2, ""), FIND(item, B2) = 0)) > 0, 0, if(len(A2) = len(B2), 2, 1)))