excel 表格公式老是出错,请大神来指导=LOOKUP(M5&N5,{"滞后较差","滞后一般","滞后良好","滞后优秀","滞后卓越","准时较差","准时一般","准时良好","准时优秀","准时卓越";"0.48","0.60","0.72","0.84","0.96","
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/24 06:12:31
![excel 表格公式老是出错,请大神来指导=LOOKUP(M5&N5,{](/uploads/image/z/2176638-6-8.jpg?t=excel+%E8%A1%A8%E6%A0%BC%E5%85%AC%E5%BC%8F%E8%80%81%E6%98%AF%E5%87%BA%E9%94%99%2C%E8%AF%B7%E5%A4%A7%E7%A5%9E%E6%9D%A5%E6%8C%87%E5%AF%BC%3DLOOKUP%28M5%26N5%2C%7B%22%E6%BB%9E%E5%90%8E%E8%BE%83%E5%B7%AE%22%2C%22%E6%BB%9E%E5%90%8E%E4%B8%80%E8%88%AC%22%2C%22%E6%BB%9E%E5%90%8E%E8%89%AF%E5%A5%BD%22%2C%22%E6%BB%9E%E5%90%8E%E4%BC%98%E7%A7%80%22%2C%22%E6%BB%9E%E5%90%8E%E5%8D%93%E8%B6%8A%22%2C%22%E5%87%86%E6%97%B6%E8%BE%83%E5%B7%AE%22%2C%22%E5%87%86%E6%97%B6%E4%B8%80%E8%88%AC%22%2C%22%E5%87%86%E6%97%B6%E8%89%AF%E5%A5%BD%22%2C%22%E5%87%86%E6%97%B6%E4%BC%98%E7%A7%80%22%2C%22%E5%87%86%E6%97%B6%E5%8D%93%E8%B6%8A%22%3B%220.48%22%2C%220.60%22%2C%220.72%22%2C%220.84%22%2C%220.96%22%2C%22)
excel 表格公式老是出错,请大神来指导=LOOKUP(M5&N5,{"滞后较差","滞后一般","滞后良好","滞后优秀","滞后卓越","准时较差","准时一般","准时良好","准时优秀","准时卓越";"0.48","0.60","0.72","0.84","0.96","
excel 表格公式老是出错,请大神来指导
=LOOKUP(M5&N5,{"滞后较差","滞后一般","滞后良好","滞后优秀","滞后卓越","准时较差","准时一般","准时良好","准时优秀","准时卓越";"0.48","0.60","0.72","0.84","0.96","0.64","0.76","0.88","1","1.12"})
滞后良好始终是指向0.48,准时一般始终指向0.88,其他的都是对的.请大家帮忙看看.
excel 表格公式老是出错,请大神来指导=LOOKUP(M5&N5,{"滞后较差","滞后一般","滞后良好","滞后优秀","滞后卓越","准时较差","准时一般","准时良好","准时优秀","准时卓越";"0.48","0.60","0.72","0.84","0.96","
公式改为:
=LOOKUP(M5&N5,{"滞后较差","滞后良好","滞后一般","滞后优秀","滞后卓越","准时较差","准时良好","准时一般","准时优秀","准时卓越";0.48,0.72,0.6,0.84,0.96,0.64,0.88,0.76,1,1.12})
出错原因,数据列表没有按升序排列.
公式也可以改为:
=LOOKUP(1,0/(M5&N5={"滞后较差","滞后一般","滞后良好","滞后优秀","滞后卓越","准时较差","准时一般","准时良好","准时优秀","准时卓越"}),{0.48,0.60,0.72,0.84,0.96,0.64,0.76,0.88,1,1.12})
(这个公式,可以不用排序.另外,如果要得出数值结果,公式中数字不用加引号.)