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

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

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

¤U¤F­Ó¸ê®ÆÀÉ¡A¥i®³¨Ó½m²ß¤½¦¡»P°ò¥»§Þ¥©¡C¾A¦X·s¤â½m²ß¥Î¡I
ºî¦Xºt½m.rar (90.29 KB)

¦^´_ 6# oobird

A2=OFFSET(¦¨ÁZ!A$1,(ROW()-2)*9+1,)&""
C2=IF(B2="","",TEXT(OFFSET(¦¨ÁZ!$D$1,(ROW()-2)*9+COLUMN(A1),)-65,"[>=20]A;C;!B"))

ºî¦Xºt½m.zip (236.96 KB)

1

µû¤À¤H¼Æ

TOP

ANGELAªº¨ç¼Æ³y¸Ú¬Û·í°ª¡A«Ü»´©öªº¸Ñ¨M³o­Ó°ÝÃD¡C
ÁöµM§Úªº­ì·N¬O·Q½Ð¤j®a©¹°ò¥»¾Þ§@ªº¤è¦V«ä¦Ò¡C¤£¹L¤£ºÞ¥Î¤°»ò¤èªk¡A³Ì²×¥ØªºÁÙ¬O¬°¤F¸Ñ¨M°ÝÃDªº¡A¸Ñ¥X¨Ó´N¬O¦nµª®×¡I

TOP

¥»©«³Ì«á¥Ñ gong ©ó 2010-12-2 15:09 ½s¿è

¼Ï¯Ã+®æ¦¡¦Û­q[>=85]!A;[<65]C;B

ºî¦Xºt½m.rar (109.3 KB)

2

µû¤À¤H¼Æ

    • Hsieh: good job !ª÷¿ú + 2
    • oobird: ¦n«ä¸ô¡Cª÷¿ú + 2
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

ÅǪ©¥D§ì¦í§Úªº¥Øªº¤F¡C¥H°ò¦¾Þ§@¹F¦¨³oºØ½ÆÂøªº¹Bºâ¡C¤ñ§Ú°µªºÂ²³æ¤F¦n´X­Ó¨BÆJ¡I
¥i¥H¦A«ä¦Ò¤@¤U¦p¦ó¨ú±oµ¥¯ÅABCªº­È¦Ó¤£¬O¼Æ¦rªº¦Û­q®æ¦¡¡I

TOP

¥»©«³Ì«á¥Ñ emma ©ó 2010-12-2 17:00 ½s¿è

¦VANGELA¤j¤j»Pgongª©¥Dªº¤èªk¾Ç²ß¤¤¡A
¦pªG¥H§Ú¦Û¤v¥»¨Óªº¤èªk¡A¥i¯à¤ñ¸û¯Ó¶O¨t²Îªº¸ê·½¡A
§Ú­ì¥»¬O¥ý¨Ï¥Î¼Ï¯Ã¡A¦A±N¨äÄæ¦ì½Æ¨î¡A
±N¤À¼ÆªºÄæ¦ì¥Î¤½¦¡=IF(ISNA(VLOOKUP($I2&K$1,$A:$E,5,0)),"",IF(VLOOKUP($I2&K$1,$A:$E,5,0)>=85,"A",IF(VLOOKUP($I2&K$1,$A:$E,5,0)>=65,"B","C")))
¥ý¦V¥k©Ô¦A©¹¤U½Æ»s....
¦p¤U¹Ï©Ò¥Ü¡A¤èªk²Â­«¤F¨Ç>"<

¤£¦n·N«ä¡A­è§Ñ¤F´£§ÚÁÙ¦³¦h¤@Äæ¡u»²§UÄæ¡v(«á¸É¤W)

1

µû¤À¤H¼Æ

    • oobird: ¤£ºÞ¶Â¿ß¥Õ¿ß¡A¯à§ì¦Ñ¹«´N¬O¦n¿ß¡Iª÷¿ú + 2

TOP

¥»©«³Ì«á¥Ñ emma ©ó 2010-12-2 17:29 ½s¿è
¼Ï¯Ã+®æ¦¡¦Û­q[>=85]!A;[
gong µoªí©ó 2010-12-2 15:00



gongª©¥D¡A¤£¦n·N«ä¡A­è¦b¨Ì±zªº¤èªk½m²ß®É¡A
µo²{±z¤å¤W¶Kªº®æ¦¡¦Û­q[>=85]!A;[<65]C;B¤Ö¤F¤@­Ó!¸¹¡A
©Ò¥H¤@ª½µLªk¦Û­q®æ¦¡¡A
«á¨Ó¤U¸ü±zªºªþ¥ó¬d¬Ý«á¡A¥¿±`ªº®æ¦¡¦Û¦¡¬O[>=85]!A;[<65]C;!B
·Ó³o­Ó¿é¤J«á´N¨S°ÝÃD¤F¡AÁÂÁÂ~~

¥t¥~¥i¥H½Ð±z¸ÑÄÀ¤@¤U!ªº¥Î·N¶Ü?
A¸òB«e­±­n¦³!
¦ýC«e­±«o¤£¥Î!
¬°¤°»ò©O?

TOP

¥»©«³Ì«á¥Ñ gong ©ó 2010-12-3 21:30 ½s¿è

1.©êºp§ÚÀ°¤£¤W¦£,¦]¬°§Ú¤]¤£ª¾¹D,¥¦¬O¦Û¤v²£¥Íªº
2.§ÚªºB«e­±¤£»Ý­n"!"(OFFICE 2000ª©¤£¥Î,XPª©Bªº«e­±¶}±Ò·|¦Û°Ê²£¥Í"!")
3.¦pªG±N"A"§ï¬°¨ä¥L­^¤å¤]¤£»Ý­n"!",¦p[>=85]Z;[<65]C;B
4[¬õ¦â][>=85]Z;[ºñ¦â][<65]X;B,
  [¬õ¦â][>=85]Z;[ºñ¦â][<65]X;[¶À¦â]B,³o¼Ë¤]¤£¥Î,
5.¸Õ¤F"D"¬O¤£¦æ¥Îªº,"A"«e­±·|¦Û°Ê²£¥Í"!"

­ì¦]¤´«Ý¨ä¥L°ª¤â¸Ñµª
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¦pD¡BE¡BGµ¥«O¯dµ¹¤é´Á¥Îªº¦r¥À¦ÛµM³£¤£¯à¥Î¡C
A·|¦Û°Ê¥[¤WÅå¹Ä¸¹¡A¦ÓB­n¦Û¤v¥[¡A¤£¥[´N³q¤£¹L(§Ú¤]·d¤£À´¬°¤°»ò)
³q±`³]©w®É·|¥ÎÂù¤Þ¸¹§â¦r¥À¬A°_¨Ó´N¨S³o¨Ç°ÝÃD¤F¡I

TOP

§ÚªºB¥i¥H¤£¥Î¥["!"

M¬O¤ë¥÷
Y¬O¦~
À³¸Ó³£¤£¯à¥Î
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

        ÀR«ä¦Û¦b : ¦Y­W¤F­W¡B­WºÉ¤Ü¨Ó¡A¨ÉºÖ¤FºÖ¡BºÖºÉ´d¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD