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

EXCEL§ì¨ú¸ê®Æ°ÝÃD

EXCEL§ì¨ú¸ê®Æ°ÝÃD

¦bsheet1¸Ì
B4 2330    G4(­n§ìSheet2¸ê®Æ)
B5 2317    G5(­n§ìSheet2¸ê®Æ)

¦bSheet2
A1 2330¥x¿n¹q      D1  10.81(­n³Q§ì¨úªº¸ê®Æ)
A2 1301¥x¶ì           D2   2.43
A3 2317ÂE®ü           D3  15.39(­n³Q§ì¨úªº¸ê®Æ)

³Æµù:
1. Sheet1  ±qB4.....¤@ª½¨ìB100
2. Sheet1  ±qSheet2§ì¨ú¹L¨Ó¸ê®Æ¥²¶·ª½±µ"Âà´«¦¨ %"
3. Sheet2  ±qA1.....¤@ª½¨ìA100³£¦³¸ê®Æ

¥ýÁÂÁ À°¦£
slip

¦³¤H·|¶Ü?§Ú¤]»Ý­n00.
·PÁ¼ö¤ßªº¤H¤F

TOP

¥»©«³Ì«á¥Ñ ANGELA ©ó 2012-5-7 15:48 ½s¿è

G4=VLOOKUP(B1&"*",Sheet2!$A$1:$D$1000,4,)
GÄæÀx¦s®æ®æ¦¡³]¬°¦Ê¤À¤ñ

TOP

¦^´_ 1# slip
½Ð±N¹ê»ÚªºÀɮפW¶Ç¡A¥H«K¤j®a¯à¤F¸Ñ§A¹ê»Úªº»Ý¨D­±¡A
ÁÂÁ¡I

TOP

¦^´_ 4# c_c_lai


¦U¦ì¤j¤j,¤w¤W¶Ç
·PÁÂÀ°¦£
slip

TOP

¦^´_ 5# slip
¤w¤W¶Ç¡H

TOP

¦^´_ 6# c_c_lai

Book555.rar (16.17 KB)

§ì¨ú¸ê®Æ

slip

TOP

¥»©«³Ì«á¥Ñ register313 ©ó 2012-5-7 17:52 ½s¿è

¦^´_ 7# slip

°ò¥»¤WANGELAª©¥D¦b2#¤w¸Ñµª¤F

¥u¬Oµo°ÝªÌÀ³«Ø¥ß¤@­ÓÆ[©À:
EXCEL¤£ºÞ¬O¤@¯ë°Ï,µ{¦¡°Ï,³£¬O¹ê»Ú¾Þ§@ªºªF¦è
µo°Ý°È¥²§â 1.¥\¯à»¡©ú²M·¡ 2.EXCELÀ£ÁYÀɤW¶Ç
¥ú¬O¤å¦r±Ô­z¬O¤£°÷ªº

Sheet2 AÄæ¨C¤@Àx¦s®æ«e³£¦h¤F­ÓªÅ¥Õ¦r¤¸
Sheet1 J4=TEXT(VLOOKUP("*"&B4&"*",Sheet2!$A$1:$D$1000,4,),"0%") ©¹¤U½Æ»s

TOP

¦^´_ 8# register313
¦^´_ 7# slip
ÁÂÁ Angela »P register313 ¨â¦ìªº¸Ñ»¡¡I
J4=TEXT(VLOOKUP("*"&B4&"*",Sheet2!$A$1:$D$100,4,)/100,"0.00%")

TOP

¦^´_ 8# register313
·PÁ¤j¤j
§Ú¸Õ¤F
ÁÙ¦³°ÝÃD¦p¤U

¦bSheet1  GÄæ¦ìÅܦ¨­ì¥»­È±o100­¿£®
½Ð¦A¦¸¨ó§U
¥t¥~¦p¦bsheet2§ì¤£¨ì¬Û¹ïÀ³¸ê®Æ,¯à§_Sheet1¤¤¤£¬OÅã¥Ü#N/A¦Ó¬O§e²{0
¦psheet1¤¤ªº102Äæ¦ì"2450¯«¸£

¦A¦¸·PÁÂ

¦~¹L¥b¦Ê¨Ó¦¹½Ð¯q...µ¹§Ú¤@­ÓÆg§a...¼K¼K
¦U¦ì°ª¤â¤j¤j,¦hÁÂÀ°¦£...

P.S:Sheet2 AÄæ¨C¤@Àx¦s®æ«e³£¦h¤F­ÓªÅ¥Õ¦r¤¸
¦]¬°¬Oª½±µ¨C¤écopy¹L¨Ó,§Ú¦³¥hÀˬd,³£¦h¤F­ÓªÅ¥Õ¦r¤¸,¦p¨S¼vÅT,³o¼Ë§Ú´N°½ÃiÄ~Äò³o¼Ë¥Î,ÁÂÁÂ

Book666.rar (17.88 KB)

­×¥¿1

slip

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD