Excel if 函数求助 在线等!!!!!!很急啊~~~

来源：百度知道 编辑：UC知道 时间：2024/05/15 15:50:11
=if(R6="Cancel PR",ABS(H6+ABS(I6-J6)+K6+N6-F6),if(R6="Move to available",K6+N6+H6-F6,if(R6="Cancel PO",K6+N6+H6-F6,if(R6="Cut PO",I6-J6,if(R6="No Problem",0,if(R6="Cancel PO ",I6-J6,if(R6="Move to WO_Res",ABS(H6+ABS(I6-J6)+K6+N6-F6),ABS(H6+ASS(I6-J6)+K6+N6-F6)-G6)))))))
怎么总是显示公式错误?

你的最后一个ABS已经超过七层嵌套了,修改方法为:

=IF(OR(R6={"Cancel PR","Move to WO_Res"}),ABS(H6+K6+N6-F6+ABS(I6-J6)),IF(OR(R6={"Move to available","Cancel PO"}),K6+N6+H6-F6,IF(R6="Cut PO",I6-J6,IF(R6="No Problem",0,ABS(H6+K6+N6-F6+ABS(I6-J6))-G6))))

注:
你原公式的这一项:if(R6="Cancel PO ",I6-J6,之前已有判断,"Cancel PO "只是比前面的多一空格,如果是重复了可以删去,公式即可正常.
=IF(R6="Cancel PR",ABS(H6+ABS(I6-J6)+K6+N6-F6),IF(R6="Move to available",K6+N6+H6-F6,IF(R6="Cancel PO",K6+N6+H6-F6,IF(R6="Cut PO",I6-J6,IF(R6="No Problem",0,IF(R6="Move to WO_Res",ABS(H6+ABS(I6-J6)+K6+N6-F6),ABS(H6+ABS(I6-J6)+K6+N6-F6)-G6))))))

最后一个分段中,你把ABS写成了ASS了吧

=if(R6="Cancel PR",ABS(H6+ABS(I6-J6)+K6+N6-F6),if(R6="Move to available",K6+N6+H6-F6,if(R6="Cancel PO",K6+N6+H6-F6,if(R6="Cut PO",I6-J6,if(R6="No Problem",0,if(R6="Cancel