你是想所有的都放到一起还是这5项分别计算?假设分为ABCDE五级,分别计算的话：

　　分值为=lookup(分值单元格,{0,60,70,80,90},{"E","D","C","B","A"})

　　单指单张为=lookup(单指单张单元格,{0,600,700,800,900},{"E","D","C","B","A"})

　　多指多张为=lookup(多指多张单元格,{0,600,700,800,900},{"E","D","C","B","A"})

　　传票翻打为=lookup(NUMBERVALUE(LEFT(传票翻打单元格,FIND("'",传票翻打单元格)-1))+NUMBERVALUE(RIGHT(传票翻打单元格,FIND("'",传票翻打单元格)))/60,{3.5,4,4.5,5,5.33},{"A","B","C","D"})

　　注：传票翻打单元格要用A‘B的时间格式,这里是文本格式的如果不是的话,请将单元格设置说明,我重新给你修改公式.

　　中文录入为=lookup(中文录入单元格,{0,200,250,300,350},{"E","D","C","B","A"})

　　如果你的要求是其他的请说详细一些