当年写的一个非常非常牛B的函数，到现在想想都想笑~

a296837698

哇。。。。厉害  学习了

Hragon

楼主，我本来以为我不会笑的，结果看着乐不可支啊！！果然像楼主这样保存着函数，时不时回味一下最好了。

表示我一上来就sumproduct的（虽然也很长），岂不是碉堡了！突然有信心了啊！谢谢楼主，楼主好人！

rakehell78

{:soso_e173:}

zhouzhaoyu

老鸟都是这样从菜鸟一步步走过来的

龙行九州

MC21/MC12：

=IF(H3="铝板3",O3*L3,)&IF(H3="铝板2",O3*L3,)&IF(H3="铝型材TD34810224S",O3*L3,)&IF(H3="不锈钢板3",O3*L3,)&IF(H3="不锈钢2",O3*L3,)&IF(H3="不锈钢1",O3*L3,)&IF(H3="不锈钢0.5",O3*L3,)&IF(F3="安全绳",G3*O3,)&IF(F3="安全锁-右",G3*O3,)&IF(F3="玻璃板4",G3*O3,)&IF(F3="防电解胶",J3*O3,)&IF(F3="过滤网",G3*O3,)&IF(F3="焊接格栅",G3*O3,)&IF(F3="合页",G3*O3,)&IF(F3="六角螺母M6",G3*O3,)&IF(F3="六角螺母M8",G3*O3,)&IF(F3="螺纹锁固胶普通型",J3*O3,)&IF(F3="毛毡",J3*O3,)&IF(F3="密封胶",J3*O3,)&IF(F3="平垫片D6",G3*O3,)&IF(F3="平垫片D8",G3*O3,)&IF(F3="裙板锁-右",G3*O3,)&IF(F3="裙板锁-左",G3*O3,)&IF(F3="三角安全锁右",G3*O3,)&IF(F3="三角安全锁左",G3*O3,)&IF(F3="橡胶夹TD63810446S",J3*O3,)&IF(F3="橡胶夹TD63810447S",J3*O3,)&IF(F3="预埋螺柱M6X20",G3*O3,)&IF(F3="预埋螺柱M8X25",G3*O3,)&IF(F3="折页",G3*O3,)&IF(F3="锥形弹垫D6",G3*O3,)&IF(F3="锥形弹垫D8",G3*O3,)&IF(F3="自夹紧式密封胶条",J3*O3,)

if(or(F3="安全绳",F3="安全锁-右",F3="玻璃板4",F3="过滤网TD71810323S",F3="过滤网TD71810323S",F3="过滤网TD71810323S",F3="过滤网TD71810323S",F3="焊接格栅TD41810289S",F3="焊接格栅TD41810290S",F3="焊接格栅TD47810231S",F3="合页",F3="六角螺母M6",F3="六角螺母M8",F3="平垫片D6",F3="平垫片D8",F3="裙板锁-右",F3="裙板锁-左",F3="三角安全锁右",F3="三角安全锁左",F3="预埋螺柱M6X20",F3="预埋螺柱M8X25",F3="折页",F3="锥形弹垫D6",F3="锥形弹垫D8"),G3*O3,if(or(F3="防电解胶"，F3="螺纹锁固胶普通型",F3="毛毡",F3="密封胶",F3="橡胶夹TD63810446S",F3="橡胶夹TD63810447S",F3="自夹紧式密封胶条"),J3*O3, if(or(H3="铝板3",H3="铝板2",H3="铝型材TD34810224S",H3="不锈钢板3",H3="不锈钢2", H3="不锈钢1",H3="不锈钢0.5"),O3*L3,”无”)))




M12/M11/M2：

=IF(H3="铝板3",P3*L3,)&IF(H3="铝板2",P3*L3,)&IF(H3="铝型材TD34810224S",P3*L3,)&IF(H3="不锈钢板3",P3*L3,)&IF(H3="不锈钢2",P3*L3,)&IF(H3="不锈钢1",P3*L3,)&IF(H3="不锈钢0.5",P3*L3,)&IF(F3="安全绳",G3*P3,)&IF(F3="安全锁-右",G3*P3,)&IF(F3="玻璃板4",G3*P3,)&IF(F3="防电解胶",J3*P3,)&IF(F3="过滤网",G3*P3,)&IF(F3="焊接格栅",G3*P3,)&IF(F3="合页",G3*P3,)&IF(F3="六角螺母M6",G3*P3,)&IF(F3="六角螺母M8",G3*P3,)&IF(F3="螺纹锁固胶普通型",J3*P3,)&IF(F3="毛毡",J3*P3,)&IF(F3="密封胶",J3*P3,)&IF(F3="平垫片D6",G3*P3,)&IF(F3="平垫片D8",G3*P3,)&IF(F3="裙板锁-右",G3*P3,)&IF(F3="裙板锁-左",G3*P3,)&IF(F3="三角安全锁右",G3*P3,)&IF(F3="三角安全锁左",G3*P3,)&IF(F3="橡胶夹TD63810446S",J3*P3,)&IF(F3="橡胶夹TD63810447S",J3*P3,)&IF(F3="预埋螺柱M6X20",G3*P3,)&IF(F3="预埋螺柱M8X25",G3*P3,)&IF(F3="折页",G3*P3,)&IF(F3="锥形弹垫D6",G3*P3,)&IF(F3="锥形弹垫D8",G3*P3,)&IF(F3="自夹紧式密封胶条",J3*P3,)


if(or(F3="安全绳",F3="安全锁-右",F3="玻璃板4",F3="过滤网TD71810323S",F3="过滤网TD71810323S",F3="过滤网TD71810323S",F3="过滤网TD71810323S",F3="焊接格栅TD41810289S",F3="焊接格栅TD41810290S",F3="焊接格栅TD47810231S",F3="合页",F3="六角螺母M6",F3="六角螺母M8",F3="平垫片D6",F3="平垫片D8",F3="裙板锁-右",F3="裙板锁-左",F3="三角安全锁右",F3="三角安全锁左",F3="预埋螺柱M6X20",F3="预埋螺柱M8X25",F3="折页",F3="锥形弹垫D6",F3="锥形弹垫D8"),G3*P3,if(or(F3="防电解胶"，F3="螺纹锁固胶普通型",F3="毛毡",F3="密封胶",F3="橡胶夹TD63810446S",F3="橡胶夹TD63810447S",F3="自夹紧式密封胶条"),J3*P3, if(or(H3="铝板3",H3="铝板2",H3="铝型材TD34810224S",H3="不锈钢板3",H3="不锈钢2", H3="不锈钢1",H3="不锈钢0.5"),P3*L3,”无”)))


Tp12/Tp11

=IF(H3="铝板3",Q3*L3,)&IF(H3="铝板2",Q3*L3,)&IF(H3="铝型材TD34810224S",Q3*L3,)&IF(H3="不锈钢板3",Q3*L3,)&IF(H3="不锈钢2",Q3*L3,)&IF(H3="不锈钢1",Q3*L3,)&IF(H3="不锈钢0.5",Q3*L3,)&IF(F3="安全绳",G3*Q3,)&IF(F3="安全锁-右",G3*Q3,)&IF(F3="玻璃板4",G3*Q3,)&IF(F3="防电解胶",J3*Q3,)&IF(F3="过滤网",G3*Q3,)&IF(F3="焊接格栅",G3*Q3,)&IF(F3="合页",G3*Q3,)&IF(F3="六角螺母M6",G3*Q3,)&IF(F3="六角螺母M8",G3*Q3,)&IF(F3="螺纹锁固胶普通型",J3*Q3,)&IF(F3="毛毡",J3*Q3,)&IF(F3="密封胶",J3*Q3,)&IF(F3="平垫片D6",G3*Q3,)&IF(F3="平垫片D8",G3*Q3,)&IF(F3="裙板锁-右",G3*Q3,)&IF(F3="裙板锁-左",G3*Q3,)&IF(F3="三角安全锁右",G3*Q3,)&IF(F3="三角安全锁左",G3*Q3,)&IF(F3="橡胶夹TD63810446S",J3*Q3,)&IF(F3="橡胶夹TD63810447S",J3*Q3,)&IF(F3="预埋螺柱M6X20",G3*Q3,)&IF(F3="预埋螺柱M8X25",G3*Q3,)&IF(F3="折页",G3*Q3,)&IF(F3="锥形弹垫D6",G3*Q3,)&IF(F3="锥形弹垫D8",G3*Q3,)&IF(F3="自夹紧式密封胶条",J3*Q3,)

if(or(F3="安全绳",F3="安全锁-右",F3="玻璃板4",F3="过滤网TD71810323S",F3="过滤网TD71810323S",F3="过滤网TD71810323S",F3="过滤网TD71810323S",F3="焊接格栅TD41810289S",F3="焊接格栅TD41810290S",F3="焊接格栅TD47810231S",F3="合页",F3="六角螺母M6",F3="六角螺母M8",F3="平垫片D6",F3="平垫片D8",F3="裙板锁-右",F3="裙板锁-左",F3="三角安全锁右",F3="三角安全锁左",F3="预埋螺柱M6X20",F3="预埋螺柱M8X25",F3="折页",F3="锥形弹垫D6",F3="锥形弹垫D8"),G3*Q3,if(or(F3="防电解胶"，F3="螺纹锁固胶普通型",F3="毛毡",F3="密封胶",F3="橡胶夹TD63810446S",F3="橡胶夹TD63810447S",F3="自夹紧式密封胶条"),J3*Q3, if(or(H3="铝板3",H3="铝板2",H3="铝型材TD34810224S",H3="不锈钢板3",H3="不锈钢2", H3="不锈钢1",H3="不锈钢0.5"),Q3*L3,”无”)))

凹凸曼小怪兽

历史的足迹，见证了你的进步

comuyou

慢慢的进步...

chenxiaying

不仅牛,而是牛上牛,最牛!!   用尽IF, 世上数你幸福!

bzhongshan

观摩一下，我是新手！

bzhongshan

看完了，没看懂，太牛逼