这个Excel公式为什么错误了?=IF(AND(D9="1-4.0",L9=1),158.8,IF(AND(D9="1-4.0",L9=2),79.4,IF(AND(D9="1-4.0",L9=3),145.9,IF(AND(D9="1-4.0",L9=4),66.5,IF(AND(D9="1-3.0",L9=1),74.4,IF(AND(D9="1-3.0",L9=2),37.2,IF(AND(D9="1-3.0",L9=3),76.8,IF(AND(D
来源:学生作业帮助网 编辑:作业帮 时间:2024/10/04 18:56:56
这个Excel公式为什么错误了?=IF(AND(D9="1-4.0",L9=1),158.8,IF(AND(D9="1-4.0",L9=2),79.4,IF(AND(D9="1-4.0",L9=3),145.9,IF(AND(D9="1-4.0",L9=4),66.5,IF(AND(D9="1-3.0",L9=1),74.4,IF(AND(D9="1-3.0",L9=2),37.2,IF(AND(D9="1-3.0",L9=3),76.8,IF(AND(D
这个Excel公式为什么错误了?
=IF(AND(D9="1-4.0",L9=1),158.8,IF(AND(D9="1-4.0",L9=2),79.4,IF(AND
(D9="1-4.0",L9=3),145.9,IF(AND(D9="1-4.0",L9=4),66.5,IF(AND(D9="1-
3.0",L9=1),74.4,IF(AND(D9="1-3.0",L9=2),37.2,IF(AND(D9="1-
3.0",L9=3),76.8,IF(AND(D9="1-3.0",L9=4),39.6,IF(AND(D9="1-
2.0",L9=1),37.6,IF(AND(D9="1-2.0",L9=2),18.8,IF(AND(D9="1-
2.0",L9=3),40.6,21.8)))此处的括号个数未知,如果公式正确的话系统会自动更正括号数量.
这个Excel公式为什么错误了?=IF(AND(D9="1-4.0",L9=1),158.8,IF(AND(D9="1-4.0",L9=2),79.4,IF(AND(D9="1-4.0",L9=3),145.9,IF(AND(D9="1-4.0",L9=4),66.5,IF(AND(D9="1-3.0",L9=1),74.4,IF(AND(D9="1-3.0",L9=2),37.2,IF(AND(D9="1-3.0",L9=3),76.8,IF(AND(D
=CHOOSE(VALUE(MID(D9,3,1))-1,CHOOSE(L9,37.6,18.8,40.6,21.8),CHOOSE(L9,74.4,37.4,76.8,39.6),CHOOSE(L9,158.8,79.4,145.9,66.5))
(认为D9只有1-4.0,1-3.0,1-2.0三种情况,L9只有1,2,3,4四种情况,其他会报错,如有其他要求请追问)