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

[µo°Ý] ¥Îif¥i¥H¤À¥X4­Óµ²ªG¶Ü

[µo°Ý] ¥Îif¥i¥H¤À¥X4­Óµ²ªG¶Ü

§Úªºexcel¤j¬ù¬O
A1-10(1°ï¼Æ¦r)
B1-10(1°ï¼Æ¦r)

¦bC1-10¥Îif¡A¦pªGA1-10¤¤¤j©ó5¬°X¡A¤p©ó¬°Y
¦bD1-10¥Îif¡A¦pªGB1-10¤¤¤j©ó20¬°A¡A¤p©ó¬°B

°ÝÃD¦b³o¸Ì
¦pªG§Ú·Qª¾¹DC1©MD1ªº²V¦X¬O¤°»ò¡A
¥i¥H¦bE1-10¤¤¼g¥XÅã¥Ü¥X¤U¦C©Ò¦³²Õ¦X¶Ü
XA/XB/YA/YB

(¨ä¹ê§ÚÁÙ¦³1­Óªº¬O·Q¤À¥XXA1/XA2/XB1/XB2/YA1/YA2/YB1/YB2ªº)

¦bE1¤¤¿é¤JIF(A1>5,"X","Y")&IF(B1>20,"A","B")¡A¦A©¹¤U©Ô¡A¬O§_´N¬O±z­nªºµª®×©O?
¥t¥~¥i¦b»¡©ú¤@¤U¡u·Q¤À¥XXA1/XA2/XB1/XB2/YA1/YA2/YB1/YB2¡vªº·N«ä¶Ü?

TOP

XA1ºq¨ìÃÑ¥ª¡A
¦pªG«Y·QXA/XB³£¥u«Y¥XX
¦ÓY´N¥XYA/YB¥i¥HÂI¼g¡A³Â·Ð®v¥S

TOP

        ÀR«ä¦Û¦b : ¦³®É·í«äµL®É­W¡A¦n¤Ñ­n¿n«B¨Ó³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD