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嵌套函数,谢谢帮忙!答:=IF(D4<0.6,0,IF(D4>=0.6,C4*0.02,IF((C4-B4)>=2000,C4*0.03,IF((C4-B4)>=3000,C4*0.04,IF((C4-B4)>=4000,C4*0.05,IF((C4-B4)>=5000,C4*0.06,)))