[已解决]求天书简化[重新上传附件]

月光不合

wn2e6fzo.rar (7.44 KB, 下载次数: 1)

2010-9-6 20:00 上传

点击文件名下载附件
求天书简化[重新上传附件]

[此贴子已经被作者于2010-9-6 20:00:17编辑过]

最佳答案

月排行榜 / 总排行榜

qinqh_yl

2010-9-7 00:20

X2=IF(OR(E2="公司",U2="未购买",N2),,(J2-(AI2%>40*H2)*(AI2-4000*H2)+W2+ISNUMBER(FIND("主机",G2))*LOOKUP(MATCH(MID(G2,4,3),{"128","160","ZK2","SC2","208","240","SC3","320","SC4","ZK4","ZK3","ZK5"},),{1,5,8,11,12;10150,17450,18750,15350,22250})*H2)*2%+V2)

原公式681字符,简化后242字符.

[此贴子已经被作者于2010-9-7 0:21:46编辑过]

跳转到最佳答案楼层

那么的帅

测试数据太少

jiangming

能稍微解释下你的计算依据吗[em04]

jiangming

还是有些问题[em06]

jiangming

还有些条件没出现，如AI列小于等于4000,G列是除了包含"AMD128Z主机",或G2="AMD160Z主机",或G2="CCDZK2主机"外的其它主机怎么算？

qinqh_yl

X2=IF(OR(E2="公司",U2="未购买",N2),,(J2-(AI2%>40*H2)*(AI2-4000*H2)+W2+ISNUMBER(FIND("主机",G2))*LOOKUP(MATCH(MID(G2,4,3),{"128","160","ZK2","SC2","208","240","SC3","320","SC4","ZK4","ZK3","ZK5"},),{1,5,8,11,12;10150,17450,18750,15350,22250})*H2)*2%+V2)

原公式681字符,简化后242字符.

[此贴子已经被作者于2010-9-7 0:21:46编辑过]

yema10000

学习。。学习。。。

月光不合

QUOTE:

以下是引用qinqh_yl在2010-9-7 0:20:00的发言：

X2=IF(OR(E2="公司",U2="未购买",N2),,(J2-(AI2%>40*H2)*(AI2-4000*H2)+W2+ISNUMBER(FIND("主机",G2))*LOOKUP(MATCH(MID(G2,4,3),{"128","160","ZK2","SC2","208","240","SC3","320","SC4","ZK4","ZK3","ZK5"},),{1,5,8,11,12;10150,17450,18750,15350,22250})*H2)*2%+V2)

原公式681字符,简化后242字符.

谢谢老师,能否解释一下,特另是1,5,8,11,12,真不明白是什么意思?