µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excel£¸¯ë°Ï
» ¨Ì·Ó¤é´Á°Ï¶¡¶ñ¤J±ø¥ó
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[µo°Ý]
¨Ì·Ó¤é´Á°Ï¶¡¶ñ¤J±ø¥ó
Genie
µoµu®ø®§
¥[¬°¦n¤Í
Genie
·í«eÂ÷½u
UID
2886
©«¤l
113
¥DÃD
31
ºëµØ
0
¿n¤À
149
ª÷¿ú
149
ÂI¦W
0
§@·~¨t²Î
xp & vista
³nÅ骩¥»
2003 & 2007
¾\ŪÅv
20
¦b½u®É¶¡
77 ¤p®É
µù¥U®É¶¡
2010-12-29
³Ì«áµn¿ý
2020-5-22
¤¤¾Ç¥Í
©«¤l
113
¥DÃD
31
ºëµØ
0
¿n¤À
149
ÂI¦W
0
§@·~¨t²Î
xp & vista
³nÅ骩¥»
2003 & 2007
¾\ŪÅv
20
µù¥U®É¶¡
2010-12-29
³Ì«áµn¿ý
2020-5-22
1
#
¸õÂà¨ì
»
¥¿§Ç¬Ý©«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2015-4-9 13:13
|
¥u¬Ý¸Ó§@ªÌ
[µo°Ý]
¨Ì·Ó¤é´Á°Ï¶¡¶ñ¤J±ø¥ó
½Ð°Ý§Ú¦³¤@°ï¤é´Á¦p excel ÀÉ A Äæ
·Qn A Äæ¨Ì·Ó F Ä檺¤é´Á°Ï¶¡±N G Ä檺±ø¥ó¶ñ¤J B Äæ
¨Ò¦p¡G1/1~1/6 ±ø¥ó¬° "-1"¡B1/7~1/15 ±ø¥ó¬° "0"¡B1/16~2/3 ±ø¥ó¬° "1"¡K¡K
§Ú¤§«e³£¬O¨Ï¥Î IF ªº¤è¦¡¼g¡A¦ý IF ¦³¨î¼h¼Æ
©Ò¥H½Ð°Ý¬O§_¦³¸û¤è«Kªº¤èªk¥i¥H§Ö³tªº±N¤£¦P¤é´Á°Ï¶¡¥N¤J±ø¥ó¡H
ÁÂÁ¡I
TEST.zip
(13.76 KB)
¤U¸ü¦¸¼Æ: 6
2015-4-9 13:12
¼Ó¥D¼ö©«
¸ê®Æª½¦VÂà¾î¦V±Æ¦C
Excel ¿z¿ï«á½Æ»s
Àx¦s®æ¤º®e
§ì¨ú°Ñ·Ó¶±ªº sheet ¦WºÙ
¸ê®Æªí®æ¯x°}Âà 90 «×
±N«½Æ¸ê®Æ§R°£
¼Ï¯Ã¤ÀªRªín«½Æpºâ
¤å¦rÂà¼Æ¦r
¤¬°Ê¦¡¹Ïªí°ÝÃD
¦p¦ó©T©wÅã¥Üªº¼ÆȦì¼Æ¡H
¦¬ÂÃ
¤À¨É
Genie
µoµu®ø®§
¥[¬°¦n¤Í
Genie
·í«eÂ÷½u
UID
2886
©«¤l
113
¥DÃD
31
ºëµØ
0
¿n¤À
149
ª÷¿ú
149
ÂI¦W
0
§@·~¨t²Î
xp & vista
³nÅ骩¥»
2003 & 2007
¾\ŪÅv
20
¦b½u®É¶¡
77 ¤p®É
µù¥U®É¶¡
2010-12-29
³Ì«áµn¿ý
2020-5-22
¤¤¾Ç¥Í
©«¤l
113
¥DÃD
31
ºëµØ
0
¿n¤À
149
ÂI¦W
0
§@·~¨t²Î
xp & vista
³nÅ骩¥»
2003 & 2007
¾\ŪÅv
20
µù¥U®É¶¡
2010-12-29
³Ì«áµn¿ý
2020-5-22
3
#
µoªí©ó 2015-4-9 15:58
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
2#
JBY
¤Ó·PÁ¤F¡I
è¥Î¤½¦¡Àˬdªþ¥óÀÉ¡@³ºµo²{¦³ condition ¼g¿ù
¯uªº¤ÓÁÂÁ¤F¡I
TOP
JBY
µoµu®ø®§
¥[¬°¦n¤Í
JBY
·í«eÂ÷½u
UID
10955
©«¤l
161
¥DÃD
0
ºëµØ
0
¿n¤À
168
ª÷¿ú
168
ÂI¦W
0
§@·~¨t²Î
Vista
³nÅ骩¥»
Office 2007
¾\ŪÅv
20
©Ê§O
¨k
¦b½u®É¶¡
222 ¤p®É
µù¥U®É¶¡
2012-9-16
³Ì«áµn¿ý
2017-2-19
¤¤¾Ç¥Í
©«¤l
161
¥DÃD
0
ºëµØ
0
¿n¤À
168
ÂI¦W
0
§@·~¨t²Î
Vista
³nÅ骩¥»
Office 2007
¾\ŪÅv
20
©Ê§O
¨k
µù¥U®É¶¡
2012-9-16
³Ì«áµn¿ý
2017-2-19
2
#
µoªí©ó 2015-4-9 14:19
|
¥u¬Ý¸Ó§@ªÌ
.....·Qn A Äæ¨Ì·Ó F Ä檺¤é´Á°Ï¶¡±N G Ä檺±ø¥ó¶ñ¤J B Äæ
B2, ¤½¦¡¦V¤U½Æ»s :
=LOOKUP(A2,F$2:G$9)
TOP
ÀR«ä¦Û¦b :
½_ÁJµ²±o¶V¹¡º¡¡A¶V·|©¹¤U««¡A¤@Ó¤H¶V¦³¦¨´N¡A´Nn¶V¦³Á¾¨Rªº¯ÝÃÌ¡C
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
EXCEL±MÄÝ°Q½×°Ï
Excel£¸¯ë°Ï
Excelµ{¦¡°Ï
¶i¶¥À³¥Î±M°Ï
OFFICE ¨t¦C
Word
PowerPoint
Access
Office¤£¤À°Ï
µ{¦¡»y¨¥
VB »P VB.Net
C »P C#
Java »P J#
µ{¦¡³]p¤£¤À°Ï
¸ê®Æ®w
ORACLE
My SQL
MS SQL
ºô¶³]p
ASP »P ASP.NET
PHP
PHP+MySQL ¤Jªù¹ê§@
JavaScript
FLASH / ActionScript
HTM/ HTML/ CSS
ºô¶³]p¤£¤À°Ï
¹q¸£»P§@·~¨t²Î
¹q¸£¦UºØµwÅé°Q½×
¤@¯ë¹q¸£³nÅé°Q½×
½×¾Â¨Æ°È
ºÞ²z¤½§i
§ë¶D¤Ï¬M
·s¤â´ú¸Õ
·R ¡E ¥Í¬¡
¤½¯q§G§iÄæ
¥Í¬¡»P·P°Ê
[¦¬Âæ¹¥DÃD]
[Ãöª`¦¹¥DÃDªº·s¦^´_]
[³q¹L QQ¡BMSN ¤À¨Éµ¹ªB¤Í]
¥Ó½Ð¤Í±¡Ãì±µ
Facebook¯»µ·