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

[µo°Ý] ¦p¦óÅý¨ç¼Æ¤¤ªº¨ç¼Æ§ó²µu?

[µo°Ý] ¦p¦óÅý¨ç¼Æ¤¤ªº¨ç¼Æ§ó²µu?

¥»©«³Ì«á¥Ñ av8d ©ó 2012-7-10 18:39 ½s¿è

¦pªGB2=¤j¤¤©Î¤j¤¤¤Ñ©Î¤j¤¤¤Ñ¤Ñ «h§PÂ_C2ªº¦r¼Æ¡A
¦pªG¦³3­Ó¦r«h C2¥ªÃä¨ú1¦r & B2 & C2¥kÃä¨ú2¦r¡A
¦pªG¦³2­Ó¦r«h C2¥ªÃä¨ú1¦r & B2 & C2¥kÃä¨ú1¦r¡A
¦pªG¦³4­Ó¦r«h C2¥ªÃä¨ú2¦r & B2 & C2¥kÃä¨ú2¦r¡C

¦pªGB2=¤¤¤¤ «h§PÂ_C2ªº¦r¼Æ¡A
¦pªG¦³3­Ó¦r«h C2¥ªÃä¨ú2¦r & C2¥ªÃä¨ú1¦r & "¦r¦ê1" & C2¥kÃä¨ú2¦r¡A
¦pªG¦³2­Ó¦r«h C2¥ªÃä¨ú2¦r & C2¥ªÃä¨ú1¦r & "¦r¦ê1" & C2¥kÃä¨ú1¦r¡A
¦pªG¦³4­Ó¦r«h C2¥ªÃä¨ú2¦r & C2¥ªÃä¨ú2¦r & "¦r¦ê1" & C2¥kÃä¨ú2¦r¡C

¦pªGB2=¤p¤¤ «h§PÂ_C2ªº¦r¼Æ¡A
¦pªG¦³3­Ó¦r«h C2¥ªÃä¨ú2¦r & C2¥ªÃä¨ú1¦r & "¦r¦ê2" & C2¥kÃä¨ú2¦r¡A
¦pªG¦³2­Ó¦r«h C2¥ªÃä¨ú2¦r & C2¥ªÃä¨ú1¦r & "¦r¦ê2" & C2¥kÃä¨ú1¦r¡A
¦pªG¦³4­Ó¦r«h C2¥ªÃä¨ú2¦r & C2¥ªÃä¨ú2¦r & "¦r¦ê2" & C2¥kÃä¨ú2¦r¡C

¨ä¾l«h§PÂ_C2ªº¦r¼Æ¡A
¦pªG¦³3­Ó¦r«h C2¥ªÃä¨ú2¦r & C2¥ªÃä¨ú1¦r & C¥kÃä¨ú2¦r & C2¥kÃä¨ú2¦r¡A
¦pªG¦³2­Ó¦r«h C2¥ªÃä¨ú2¦r & C2¥ªÃä¨ú1¦r & C¥kÃä¨ú2¦r & C2¥kÃä¨ú1¦r¡A
¦pªG¦³4­Ó¦r«h C2¥ªÃä¨ú2¦r & C2¥ªÃä¨ú2¦r & C¥kÃä¨ú2¦r & C2¥kÃä¨ú2¦r¡C

¥H¤W¦pªG¬O®{ªk·Ò¿û«h¬O
IF(OR(B2="¤j¤¤",B2="¤j¤¤¤Ñ",B2="¤j¤¤¤Ñ¤Ñ"),IF(LEN(C2)=3,LEFT(C2)&RIGHT(B2,2)&RIGHT(C2,2),IF(LEN(C2)=2,LEFT(C2)&RIGHT(B2,2)&RIGHT(C2),IF(LEN(C2)=4,LEFT(C2,2)&RIGHT(B2,2)&RIGHT(C2,2))))
¤@ª½¼g¤U¥h~·|Åý¨ç¼Æ«Üªø~¬O§_¦³Â²µuªº¤èªk?

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD