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

来源：学生作业帮编辑：作业帮分类：综合作业时间：2024/05/17 02:57:30

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)

括号的位置不对了.
=TRUNC(IF(AND(A8$B$5),B8-(($A$5-A8)/$C$5*$N$5+2%)*$D$5,B8-$D$5*$G$5),4)