excel函数嵌套出错

来源：百度知道 编辑：UC知道 时间：2024/06/05 19:08:09
=INDEX(IF(AA3=0.63,'D:\管径\[管子内径.xls]Sheet2'!$A$3:$A$24,IF(AA3=0.8,'D:\管径\[管子内径.xls]Sheet2'!$F$3:$F$24,IF(AA3=1,'D:\管径\[管子内径.xls]Sheet2'!$K$3:$K$24,IF(AA3=1.25,'D:\管径\[管子内径.xls]Sheet2'!$P$3:$P$24,IF(AA3=1.6,'D:\管径\[管子内径.xls]Sheet2'!$U$3:$U$24,IF(AA3=2,'D:\管径\[管子内径.xls]Sheet2'!$Z$3:$Z$24,'D:\管径\[管子内径.xls]Sheet2'!$AE$3:$AE$24)))))),MATCH(MIN(ABS(IF(AA3=0.63,'D:\管径\[管子内径.xls]Sheet2'!$A$3:$A$24,IF(AA3=0.8,'D:\管径\[管子内径.xls]Sheet2'!$F$3:$F$24,IF(AA3=1,'D:\管径\[管子内径.xls]Sheet2'!$K$3:$K$24,IF(AA3=1.25,'D:\管径\[管子内径.xls]Sheet2'!$P$3:$P$24,IF(AA3=1.6,'D:\管径\[管子内径.xls]Sheet2'!$U$2:$U$24,IF(AA3=2,'D:\管径\[管子内径.xls]Sheet2'!$Z$2:$Z$24,'D:\管径\[管子内径.xls]Sheet2'!$AE$2:$AE$24))))))-H3)),ABS(IF(AA3=0.63,'D:\管径\[管子内径.xls]Sheet2'!$A$3:$A$24,IF(AA3=0.8,'D:\管径\[管子内

多条件IF可改用MATCH或LOOKUP函数。
IF(AA3=0.63,'D:\管径\[管子内径.xls]Sheet2'!$A$3:$A$24,IF(AA3=0.8,'D:\管径\[管子内径.xls]Sheet2'!$F$3:$F$24,IF(AA3=1,'D:\管径\[管子内径.xls]Sheet2'!$K$3:$K$24,IF(AA3=1.25,'D:\管径\[管子内径.xls]Sheet2'!$P$3:$P$24,IF(AA3=1.6,'D:\管径\[管子内径.xls]Sheet2'!$U$3:$U$24,IF(AA3=2,'D:\管径\[管子内径.xls]Sheet2'!$Z$3:$Z$24,'D:\管径\[管子内径.xls]Sheet2'!$AE$3:$AE$24))))))
这段可简化为：
OFFSET('D:\管径\[管子内径.xls]Sheet2'!$A$1,2,IF((AA3>=0.63)*(AA3<=2),(MATCH(AA3,{0.63,0.8,1,1.25,1.6,2})-1)*5,30),22,1)
其它内容可参考此方法简化。

您能把你要实现的功能说明一下吗？
我看着都乱了
要么加qq也行574450968