多选题的自动改卷 (9544)

少选為 0.5分 D2{=(2-(COUNT(0/(FIND(MID(C2,ROW($1:$4),1),"@"&B2)>1))<>LEN(B2))*1.5)*(LEN(B2)>=LEN(C2))*(COUNT(FIND(MID(C2,ROW($1:$4),1),B2))=4)

少选一格 扣 0.5分 E2{=(2-(LEN(B2)-COUNT(0/(FIND(MID(C2,ROW($1:$4),1),"@"&B2)>1)))*0.5)*(COUNT(0/FIND(MID(C2,ROW($1:$4),1),"@"&B2))=4)