作业帮excel 表格公式老是出错,请大神来指导=LOOKUP(M5&N5,{"滞后较差","滞后一般","滞后良好","滞后优秀","滞后卓越","准时较差","准时一般","准时良好","准时优秀","准时卓越";"0.48","0.60","0.72","0.84","0.96","
来源：学生作业帮助网 编辑：作业帮 时间：2024/11/17 07:22:33
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})
（这个公式,可以不用排序.另外,如果要得出数值结果,公式中数字不用加引号.）