Question

请问Excel里怎么将五级制的等级分转换成百分制的分数?

Answer 1

上表格图来看一下表格结构,要带上行号列标

不上图就只能假设数据在A1单元格,则另一单元格写入公式

=IF(A1="A",95,IF(A1="B",85,IF(A1="C",75,IF(OR(A1={"D","E"}),65,""))))

或

=IF(A1="","",VLOOKUP(A1,{"A",95;"B",85;"C",75;"D",65;"E",65},2,))