问题描述:
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,其他的都是对的.请大家帮忙看看.
=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,其他的都是对的.请大家帮忙看看.
问题解答:
我来补答展开全文阅读