[求助] 函数突破了7层,如何换种方法表示 ?=IF(X3>0,"A",IF((W3+V3)>0,"B",IF((T3+U3)>0,"C",IF(S3>0,"D",IF(R3>0,"E",IF(Q3>0,"F",IF(O3>0,"G",IF(N3>0,"H",IF(M3>0,"I",IF(L3>0,"J",IF(K3>0,"K",IF(J3>0,"L",IF(I3>0,"M","")))))))))))))))))函数突

来源:学生作业帮助网 编辑:作业帮 时间:2024/11/15 15:39:20

[求助] 函数突破了7层,如何换种方法表示 ?=IF(X3>0,"A",IF((W3+V3)>0,"B",IF((T3+U3)>0,"C",IF(S3>0,"D",IF(R3>0,"E",IF(Q3>0,"F",IF(O3>0,"G",IF(N3>0,"H",IF(M3>0,"I",IF(L3>0,"J",IF(K3>0,"K",IF(J3>0,"L",IF(I3>0,"M","")))))))))))))))))函数突
[求助] 函数突破了7层,如何换种方法表示 ?
=IF(X3>0,"A",IF((W3+V3)>0,"B",IF((T3+U3)>0,"C",IF(S3>0,"D",IF(R3>0,"E",IF(Q3>0,"F",IF(O3>0,"G",IF(N3>0,"H",IF(M3>0,"I",IF(L3>0,"J",IF(K3>0,"K",IF(J3>0,"L",IF(I3>0,"M","")))))))))))))))))
函数突破了7层,如何表示,2003版.

[求助] 函数突破了7层,如何换种方法表示 ?=IF(X3>0,"A",IF((W3+V3)>0,"B",IF((T3+U3)>0,"C",IF(S3>0,"D",IF(R3>0,"E",IF(Q3>0,"F",IF(O3>0,"G",IF(N3>0,"H",IF(M3>0,"I",IF(L3>0,"J",IF(K3>0,"K",IF(J3>0,"L",IF(I3>0,"M","")))))))))))))))))函数突
不要尝试在 一个 公式里算出所有的 ,添加一些中间计算列 ,把公式中间的函数用额外的计算列算出来