你输入的公式存在错误.如果你输入的内容不是公式,请在第一个字符之前输入单引号(').请问是那里错了.=IF(AND(E10=450,H10=1),"3.3",IF(AND(E10=450,H10=1.5),"4.9",IF(AND(E10=450,H10=1.6),"5.3",IF(AND(E10=450,H10=1.75),

Question

你输入的公式存在错误.如果你输入的内容不是公式,请在第一个字符之前输入单引号(').请问是那里错了.
=IF(AND(E10=450,H10=1),"3.3",IF(AND(E10=450,H10=1.5),"4.9",IF(AND(E10=450,H10=1.6),"5.3",IF(AND(E10=450,H10=1.75),"5.7",IF(AND(E10=630,H10=1),"4.5",IF(AND(E10=630,H10=1.5),"6.8",IF(AND(E10=630,H10=1.6),"7.2",IF(AND(E10=800,H10=1),"5.5",IF(AND(E10=800,H10=1.5),"8.3",IF(AND(E10=800,H10=1.6),"8.8",IF(AND(E10=800,H10=1.75),"9.6",IF(AND(E10=800,H10=2),"11",IF(AND(E10=1000,H10=1),"6.7",IF(AND(E10=1000,H10=1.5),"10",IF(AND(E10=1000,H10=1.6),"10.7",IF(AND(E10=1000,H10=1.75),"11.7",IF(AND(E10=1000,H10=2),"13.4")))))))))))))))))

Answer 1

IF嵌套超过7层.
请上传带行号列标的表格截图,并说明你的要求.可能会有高手给你一个更简洁的公式.