Excel中请问如何将两条函数结合使用答:IF(E5<=5,"-1"))+IF(E4>5,"1",IF(E4<=5,"-1"))+IF(E3>5,"1",IF(E3<=5,"-1"))+IF(E2>5,"1",IF(E2<=5,"-1"))+IF(E1>5,"1",IF(E1<=5,"-1")))就是用CHOOSE函数,也可以用IF函数,=IF(b12=1,IF(B5<=5,"1",IF(B5>5,"-1"))+IF(B4<=5,"1",...
Excel 公式套用公式,公式中包含公式答:定义一个名称 _Indirect=ROW(INDIRECT("Z1:Z"&LEN(Sheet1!$A$1)))A2:=IF(A1="","",TEXT(SUM(--MID(A$1,_Indirect,1)*(10^_Indirect)/10),REPT("0",LEN($A$1)))数组公式,Ctrl+Shift+Enter三键结束公式输入 A3:=IF(A1="","",TEXT(ABS(A1-A2),REPT("0",LEN($A$1))...