跪求EXCEL高手帮忙编出分数公式

你是想所有的都放到一起还是这5项分别计算？假设分为ABCDE五级，分别计算的话： 分值为=lookup(分值单元格,{0,60,70,80,90},{"E","D","C","B","A"}) 单指单张为=lookup(单指单张单元格,{0,600,700,800,900},{"E","D","C","B","