UC知道求助：EXCEL函数
来源：百度知道 编辑：UC知道 时间：2024/05/17 08:49:26
大家来帮我看一下这个函数，为什么我输入的这个的时候出现问题了呢~提示有错误，高手请指点！！
=if((ROUNDDOWN(DAYS360(B9,$G$9)/30,0))<=12,ROUNDDOWN(DAYS360(B9,$G$9)/30,if((ROUNDDOWN(DAYS360(B9,$G$9)/30,0))<=C9*12,if((ROUNDDOWN(DAYS360(B9,$G$9)/30,0))=C9*12,1,if((ROUNDDOWN(DAYS360(B9,$G$9)/30,0))=(C9*12-1),2,if((ROUNDDOWN(DAYS360(B9,$G$9)/30,0))=(C9*12-2),3,if((ROUNDDOWN(DAYS360(B9,$G$9)/30,0))=(C9*12-3),4,if((ROUNDDOWN(DAYS360(B9,$G$9)/30,0))=(C9*12-4),5,if((ROUNDDOWN(DAYS360(B9,$G$9)/30,0))=(C9*12-5),6,if((ROUNDDOWN(DAYS360(B9,$G$9)/30,0))=(C9*12-6),7,if((ROUNDDOWN(DAYS360(B9,$G$9)/30,0))=(C9*12-7),8,if((ROUNDDOWN(DAYS360(B9,$G$9)/30,0))=(C9*12-8),9,if((ROUNDDOWN(DAYS360(B9,$G$9)/30,0))=(C9*12-9),10,if((ROUNDDOWN(DAYS360(B9,$G$9)/30,0))=(C9*12-10),11,if((ROUNDDOWN(DAYS360(B9,$G$9)/30,0))=(C9*12-11),12,0)))))))))))))))
=if((ROUNDDOWN(DAYS360(B9,$G$9)/30,0))<=12,ROUNDDOWN(DAYS360(B9,$G$9)/30,if((ROUNDDOWN(DAYS360(B9,$G$9)/30,0))<=C9*12,if((ROUNDDOWN(DAYS360(B9,$G$9)/30,0))=C9*12,1,if((ROUNDDOWN(DAYS360(B9,$G$9)/30,0))=(C9*12-1),2,if((ROUNDDOWN(DAYS360(B9,$G$9)/30,0))=(C9*12-2),3,if((ROUNDDOWN(DAYS360(B9,$G$9)/30,0))=(C9*12-3),4,if((ROUNDDOWN(DAYS360(B9,$G$9)/30,0))=(C9*12-4),5,if((ROUNDDOWN(DAYS360(B9,$G$9)/30,0))=(C9*12-5),6,if((ROUNDDOWN(DAYS360(B9,$G$9)/30,0))=(C9*12-6),7,if((ROUNDDOWN(DAYS360(B9,$G$9)/30,0))=(C9*12-7),8,if((ROUNDDOWN(DAYS360(B9,$G$9)/30,0))=(C9*12-8),9,if((ROUNDDOWN(DAYS360(B9,$G$9)/30,0))=(C9*12-9),10,if((ROUNDDOWN(DAYS360(B9,$G$9)/30,0))=(C9*12-10),11,if((ROUNDDOWN(DAYS360(B9,$G$9)/30,0))=(C9*12-11),12,0)))))))))))))))
if语句嵌套太多,有13个,本身只能用7次嵌套的,你需要做优化
也许可以把上面语句分成两个公式,后面的6个if放在另外单元格里面,前面的if引用他们的结果值
if 只能套7次
请把附件发送到29748125@qq.com
用定义名称来解决吧,选择你要插入函数的单元格,点击"插入\名称\定义",随便输入一个名称,例如"aaaa",在引用位置中输入你的公式,然后确定关闭窗口,在要插入函数的单元格中输入"=aaaa"就可以了.