|
师傅你好：
下面的函数在使用过程中在范围内，得出的结果不一样，请师傅指正，谢谢！
IF([部门]="导线" And [内宽] > "100" And [内宽] <= "600","M12",IF([部门]="导线" And [内宽] > "600" And [内宽] <= "900","M14",IF([部门]="导线" And [内宽] > "900" And [内宽] <= "960","M16",IF([部门]="导线" And [内宽] > "960","M18",IF([部门]="南绞线" And [规格] < "1210","M12",IF([部门]="南绞线" And [规格] >"1210","M14",IF([部门]="北绞线" And [规格] < "1210","M12",IF([部门]="北绞线" And [规格] > "1210" ,"M14",IF([部门]="拉丝" And [规格] < "1210","M12",IF([部门]="拉丝" And [规格] > "1210" ,"M14",IF([部门]="普缆" And [规格] < "1800","M14",IF([部门]="普缆" And [规格] >= "1800","M16",IF([部门]="特缆" And [规格] < "1800","M14",IF([部门]="特缆" And [规格] >= "1800","M16",IF([部门]="光缆" And [规格] < "1800","M14",IF([部门]="光缆" And [规格] >= "1800","M16",IF([部门]="南日立" And [规格] < "1800","M14",IF([部门]="南日立" And [规格] >= "1800","M16",IF([部门]="东日立" And [规格] < "1800","M14",IF([部门]="东日立" And [规格] >= "1800","M16",IF([部门]="西日立" And [规格] < "1800","M14",IF([部门]="西日立" And [规格] >= "1800","M16",0))))))))))))))))))))))
|
加好友 
发短信
Post By：2011/11/11 18:20:00 [显示全部帖子]
Post By：2011/11/11 19:29:00 [显示全部帖子]
Post By：2011/11/11 20:37:00 [显示全部帖子]
Post By：2011/11/12 9:35:00 [显示全部帖子]
