if函数写的太长了无法运算

NearNathan · 发表于 2020-8-4 19:11

=iF(and(AA6<>"",AC6=""),DATEDIF(B6,Z6,"D")*L6*$BB$2+DATEDIF(R6,Z6,"D")*T6*$BB$2,if(and(AC6<>"",AA6<L6),AA6*DATEDIF(B6,Z6,"D")+(L6-AA6)*DATEDIF(B6,AB6,"D")+(S6-L6)*DATEDIF(R6,AB6,"D"))*$BB$2,if(and(AC6<>"",AA6>L6),(L6*DATEDIF(B6,Z6,"D"+(AA6-L6)*DATEDIF(R6,Z6,"D")+(S6-AA6)*DATEDIF(R6,AB6,"D"))*$BB$2)))
这是用来计算利息的公式，因为回款金额经常包含两个时间段的金额，需要分别核算，写完一直提示参数太多了，没法运算，有什么方法可以把需要多个条件的if函数转换为可运算的函数吗？VBA是不是可以实现呢？求大神指点。

haoma125 · 发表于 2020-8-5 11:17

多了一个括号

=IF(AND(AA6<>"",AC6=""),DATEDIF(B6,Z6,"D")*L6*$BB$2+DATEDIF(R6,Z6,"D")*T6*$BB$2,IF(AND(AC6<>"",AA6<L6),AA6*DATEDIF(B6,Z6,"D")+(L6-AA6)*DATEDIF(B6,AB6,"D")+(S6-L6)*DATEDIF(R6,AB6,"D")*$BB$2,IF(AND(AC6<>"",AA6>L6),(L6*DATEDIF(B6,Z6,"D"+(AA6-L6)*DATEDIF(R6,Z6,"D")+(S6-AA6)*DATEDIF(R6,AB6,"D"))*$BB$2))))

复制代码

NearNathan · 发表于 2020-8-5 15:04

haoma125 发表于 2020-8-5 11:17
多了一个括号

感谢大神，纠结了好久了

		自动登录	找回密码
密码			免费注册

[求助] if函数写的太长了无法运算