WPS表格2013制作音序检测评分问卷
①启动WPS表格2013,首先输入题目,以及一些信息。
②在C2单元格,输入函数公式:=LOOKUP(CODE(A2),45217 {0,36,544,1101,1609,1793,2080,2560,2902,3845,4107,4679,5154,5397,5405,5689,6170,6229,......
②在C2单元格,输入函数公式:=LOOKUP(CODE(A2),45217 {0,36,544,1101,1609,1793,2080,2560,2902,3845,4107,4679,5154,5397,5405,5689,6170,6229,......
