EXCELյļԭ

1.ؼ͹ʽá
=====================================
  ѹơsheet1Ϊʹý̡̳ġʹýָ̡̳J5ҪĵԪK5ҪóĵԪ

һáʹý̡̳K5ԪʽжơX

               Excel˵ġ롱ơ塱ڡڵǰеơ棬"X"ӡĿհ״ͳˡXѡXλ 롰 =EVALUATE(SUBSTITUTE(SUBSTITUTE(ʹý̳!$J5"[""*ISTEXT(""[")"]""]"")"))ȷرմڡ

ڶáʹý̡̳K5Ĺʽ

        ڡʹý̡̳K5Ԫ빫ʽ=IF(J5=""""x)XǸոնƣһѾˣJ5
      ָԪJ5м㹫ʽĵԪ񡣹ʽ=IF(J5=""""x)ʾJ5ԪǿհףK5ԪҲΪհףJ5Ԫ
      ǿհףK5ԪڶơXK5Ԫ¸ƣԼҪ

֤ʽȷԣ

     J5Ԫ롰0.24[ǽ]*(3.6[ǽ]*3[ǽ]-0.9*1.8[۳C1021])ǲ2.2ǣ֤ʽǶԵ

2.˵ֻʵֿ룬(3ַ)
=================================================================

һֱ룺
    1.ѡҪõĵԪƩA1Ԫ
    2.ѡ˵ġݡЧԡ֡Чԡڣ
    3.ڡáѡСЧѡСұߵġԿֵ͡ṩ˵ȫ򹴡ڡԴݣƩ 123456789(˫ţָšΪģʽ)ȷOKˣٴѡA1Ԫ񣬾ͳ˵


ͬһڵݣ
     ͬһĳо˵ҪݣƩùSheet1B2B5B2B5ֱݣ1234£
    1.ѡҪõĵԪƩA1Ԫ
    2.ѡ˵ġݡЧԡ֡Чԡڣ
    3.ڡáѡСЧѡСұߵġԿֵ͡ṩ˵ȫ򹴡ڡԴݡ=$ B$2:$B$5Ҳ԰ұߴɫͷֱѡB2B5ȷOKˣٴѡA1Ԫ񣬾ͳ˵


òͬڵݣõƣ
    ͬĳо˵ҪݣƩ繤Sheet1A1ԪҪùSheet2B2B5򣬹Sheet2B2B5ֱݣ1234£
    1.ƣ˵롱ơ塱ơڣڡڵǰеơ롰DWԼ λá롰=Sheet2!$B$2:$B$5Ҳ԰ұߴɫͷֱѡB2B5ӡٰȷɵһ
    2.ѡ˵ġݡЧԡ֡Чԡڣ
    3.ڡáѡСЧѡСұߵġԿֵ͡ṩ˵ȫ򹴡ڡԴ롰=DWDWǸոնõƣȷOKˣٴѡA1Ԫ񣬾ͳ˵


Ͼ3򵥵ĲȻҲVBAʵ֡

ע⣺ֻ֣֣ܶĸãڻȥͼûãΪԣʹֻݡ

3.IFʽãҿԿҲϸ˵
====================
