¥»©«³Ì«á¥Ñ 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? |