EXCEL中IF函数多层嵌套问题答:=IF(OR(A1=500,A1=600),IF(B1<30,5.5,IF(B1>40,11,7.5)),IF(A1=800,IF(B1<30,18.5,22),IF(OR(A1=1000,A1=1200),IF(B1<30,22,IF(B1>45,45,IF(AND(B1>=30,B1<=38),30,37))),IF(A1=1400,IF(B1<30,37,55)))如果不支持7层嵌套,可以用CHOOSE函数 =CHOOSE(OR(A1...
excel的if函数多个嵌套答:LOOKUP(A1,{0,50,150,250,350,450,550,650,750},{4.5,5.6,6.7,7.6,8.6,9.6,10.6,11.6})第一个数组前需加0,否则50以内的数无法判断
excel中if函数的多层嵌套答:亲,完全按照你文字描述写的,逻辑性对不对就没做判断了:=IF(AND(K1=0,L1=0),J1,IF(AND(H1>K1,K1>0,L1=0),K1-H1+I1,IF(AND(K1>H1,L1=0),K1+I1,IF(AND(I1>L1,L1>0,K1=0),L1-I1+K1,IF(AND(L1>I1,K1=0),L1+H1,IF(AND(K1>0,L1>0),K1+L1,"")))...
excel if函数如何实现多级嵌套答:A1<=50,Sheet2!$B$2,IF(Sheet1!A1<=75,Sheet2!$B$3,IF(Sheet1!A1<=100,Sheet2!$B$4,IF(Sheet1!A1<=125,Sheet2!$B$5,IF(Sheet1!A1<=150,Sheet2!$B$6,IF(Sheet1!A1<=175,Sheet2!$B$7,IF(Sheet1!A1<=200,Sheet2!$B$8,Sheet2!$B$9)))不过好像if函数嵌套层数是有限...