Excel中请问如何将两条函数结合使用

=CHOOSE(B12,IF(B5<=5,"1",IF(B5>5,"-1"))+IF(B4<=5,"1",IF(B4>5,"-1"))+IF(B3<=5,"1",IF(B3>5,"-1"))+IF(B2<=5,"1",IF(B2>5,"-1"))+IF(B1<=5,"1",IF(B1>5,"-1")),IF(E5>5,"1",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",IF(B4>5,"-1"))+IF(B3<=5,"1",IF(B3>5,"-1"))+IF(B2<=5,"1",IF(B2>5,"-1"))+IF(B1<=5,"1",IF(B1>5,"-1")),IF(E5>5,"1",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")))

在你的公式中用上一个函数ROUND

格式为

=ROUND(原公式,2)

后面的2是要保留的小数位数，这个函数会四舍五入的保留。

当然，你设置单元格的格式也是可以的。