[已解决]B列公式帮我简化一下谢谢。

baksy

C列公式；
C2=TEXT(IF(B2="","",IF(D2="密集",IF(B2={0.25,0.275,0.3,0.35,3},{0.01,0.012,0.02,0.01,-0.01},"0")))+IF(B2<1.661,IF(D2="长槽",-0.01,IF(D2="短槽",-0.009,0)),),"0.000")

fangniuji

baksy 发表于 2014-2-23 08:36
C列公式；
C2=TEXT(IF(B2="","",IF(D2="密集",IF(B2={0.25,0.275,0.3,0.35,3},{0.01,0.012,0.02,0.01,-0.0 ...

还有一点小问题，帮我看看，谢谢

baksy

fangniuji 发表于 2014-2-23 12:59
还有一点小问题，帮我看看，谢谢

F列公式是我给你改过的C列的公式啊

fangniuji

baksy 发表于 2014-2-23 13:17
F列公式是我给你改过的C列的公式啊

结果还不行F2=0.02，没出来

baksy

fangniuji 发表于 2014-2-23 14:29
结果还不行F2=0.02，没出来

=TEXT(IF(B2="","",IF(D2="密集",SUMPRODUCT((B2={0.25,0.275,0.3,0.35,3})*({0.01,0.012,0.02,0.01,-0.01}))))+IF(B2<1.661,IF(D2="长槽",-0.01,IF(D2="短槽",-0.009,0)),),"0.000")