excel 输入函数太多 TRUNC(IF(AND(A8<$A$5,A8>$B$5),B8-(($A$5-A8)/$C$

问题描述:

excel 输入函数太多 TRUNC(IF(AND(A8<$A$5,A8>$B$5),B8-(($A$5-A8)/$C$5*$N$5+2%)*$D$5,B8-$D$5*$G$5,4)
1个回答 分类:综合 2014-12-06

问题解答:

我来补答
括号的位置不对了.
=TRUNC(IF(AND(A8$B$5),B8-(($A$5-A8)/$C$5*$N$5+2%)*$D$5,B8-$D$5*$G$5),4)
 
 
展开全文阅读
剩余:2000
也许感兴趣的知识