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

¤½¦¡»P°ò¥»§Þ¥©ºt½m

¦^´_ 20# zeny
³o¨ÇÀx¦s®æ¤º®e³£Åܦ¨¤F¤é´Á
³o¬O§A¨Ï¥Îbbªº½t¬G
¦Û­q®æ¦¡§ï¦¨
[>=85]!A;[>=65]!B;C
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¸g¤j«ü¥¿¡Aª¾¹D¦Û¤v¿ù¦b¤F­þ¸Ì

¥»©«³Ì«á¥Ñ zeny ©ó 2011-8-14 13:26 ½s¿è
¦^´_  zeny
³o¨ÇÀx¦s®æ¤º®e³£Åܦ¨¤F¤é´Á
³o¬O§A¨Ï¥Îbbªº½t¬G
¦Û­q®æ¦¡§ï¦¨
[>=85]!A;[>=65]!B;C
Hsieh µoªí©ó 2011-8-12 22:08



   ¬Oªº¡A¬Oªº¡A§Ú¨S¦³ª`·N¨ì¤j¤j¤§«e¼gªº
B­ì«h¤W¤]ºâ«O¯d¦r
­Y¿é¤JB¡AEXCEL·|¦Û°Ê§ï¦¨bb
Åã¥Ü¼Æ­È¥H1900¦~¬°43°_ºâªº¦~«×
1900¦~¤é´ÁÅã¥Ü¦¨43
1901¦~¤é´ÁÅã¥Ü¦¨44
¥H¦¹Ãþ±À
¥[¤WÅå¹Ä¸¹!©Î¤Ï±×½u\©Î¥ÎÂù¤Þ¸¹""
³£¥Nªí¨Ï¥Î¦r¤¸
¥u¬O¤Ï±×½u·|³QEXCEL¦Û°ÊÂনÅå¹Ä¸¹

²{¦b¤w¸g¦¨¥\¤F¡C
¯u¬O¶V¾Ç¡A¶Vı±o¦Û¤v²LÁ¡
ÁÂÁ¤j¤j¡C
pivotetable©Mvlookupºî¦XÀ³¥Î.rar (11.21 KB)
§Ú³ß欢 excel

TOP

¼Ï¯Ã¡÷±N®æ¤l½Æ»s¨ì¥kÃä¡÷¿é¤J¤½¦¡
    IF(C5<65,"C",IF(C5<85,"B","A"))

123.JPG (241.39 KB)

123.JPG

Kenny

TOP

¥»©«³Ì«á¥Ñ ky2599y ©ó 2011-8-16 21:19 ½s¿è

¼Ï¯Ã¡÷ª½±µ¨ì¼Ï¯Ãªí¸Ì¥h³]Àx¦s®æ®æ¦¡

456.JPG (123.94 KB)

456.JPG

Kenny

TOP

·PÁ§Aªº¤À¨É

TOP

        ÀR«ä¦Û¦b : ¡i¬°µ½Ävª§¡j¤H¥Í­n¬°µ½Ävª§¡A¤À¬í¥²ª§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD