传票录入分数

发布网友发布时间：2023-03-17 14:40

共1个回答

热心网友时间：2023-11-03 23:15

你是想所有的都放到一起还是这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"})
如果你的要求是其他的请说详细一些