ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ½Ð°Ý ¦h­«§PÂ_ ¦A§@­pºâ À³¸Ó¦p¦ó³B²z¤ñ¸û¦n

[µo°Ý] ½Ð°Ý ¦h­«§PÂ_ ¦A§@­pºâ À³¸Ó¦p¦ó³B²z¤ñ¸û¦n

½Ð°Ý ¦h­«§PÂ_  ¦A§@­pºâ À³¸Ó¦p¦ó³B²z¤ñ¸û¦n
¦h­«§PÂ_.rar (4.03 KB)
HI

=INDEX(B2:E4,MATCH(A6,{0,1,2}),MATCH(B6,{0,20,30,40}))

TOP

=INDEX(B2:E4,MATCH(A6,{0,1,2}),MATCH(B6,{0,20,30,40}))
oobird µoªí©ó 2010-11-10 23:44

  ÁÂÁÂ
¥i¥H §PÂ_«á ª½±µºâ¥Xµ²ªG¶Ü¡H
¦]¬°¤è«K ¤j¤j«ü¾É ©Ò¥Hµeªí®æ¥X¨Ó   
§Ú·Q ª½±µÅã¥Ü¥X­pºâµ²ªG À³¸Ó«ç»ò³B²z©O
HI

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2010-11-11 00:20 ½s¿è

=$F$1*$G$1*((LOOKUP($A$6,{0,1,2,3},ROW($A$2:$A$4))-2)*4+LOOKUP($B$6,{0,20,30,40},COLUMN($B$1:$E$1))-2)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

=$F$1*$G$1*((LOOKUP($A$6,{0,1,2,3},ROW($A$2A$4))-2)*4+LOOKUP($B$6,{0,20,30,40},COLUMN($B$1E$1))- ...
Hsieh µoªí©ó 2010-11-11 00:11


  ÁÂÁÂ
¥i¥H §PÂ_«á ª½±µºâ¥Xµ²ªG¶Ü¡H
¦]¬°¤è«K ¤j¤j«ü¾É ©Ò¥Hµeªí®æ¥X¨Ó   
§Ú·Q ª½±µÅã¥Ü¥X­pºâµ²ªG À³¸Ó«ç»ò³B²z©O
¦]¬°§ÚÁٻݭn§@«áÄò³B²z
ÁÙ¬O ª©¥D»{¬° µe¥Xªí®æ ¤ñ¸û®e©ö³B²z
HI

TOP

¦^´_ 5# mycmyc


    ³o¼Ëªº¤½¦¡¦bC6¤£¬O´N¯à±o¨ì¼Æ­È¤F¶Ü?
§A§âªí®æ³£§R¤F¸Õ¸Õ¬Ý
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

³Ì«á¨â­Ó³£¬O*12¶Ü¡H

TOP

¦^´_  mycmyc


    ³o¼Ëªº¤½¦¡¦bC6¤£¬O´N¯à±o¨ì¼Æ­È¤F¶Ü?
§A§âªí®æ³£§R¤F¸Õ¸Õ¬Ý
Hsieh µoªí©ó 2010-11-11 00:27


ÁÂÁ §Ú¬ã¨s¬Ý¬Ý ¦³ÂIÃø  
¸U¨Æ°_ÀYÃø  ­n¾ÇªºÁÙ¯u¦h ÁÂÁÂ
HI

TOP

³Ì«á¨â­Ó³£¬O*12¶Ü¡H
oobird µoªí©ó 2010-11-11 08:14


ÁÂÁ ¬Oªº  ¯Ç¦h¬O12
HI

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD