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

excel ¤½¦¡Â²¤Æ

excel ¤½¦¡Â²¤Æ

1.½Ð°Ý¦³¨S¨ä¥L²³æªº¤èªk,¤£¥Î³v¶µ¥[¤W?
2.¦pB11¨S¦³¸ê®Æ,«ç»ò¨ú®øe11³Ì«áªº¨º­Ó"©M"¦r

TEST08.png (83.37 KB)

TEST08.png

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 2# hcm19522

¬Ý¤£¨ì

TOP

¦^´_ 3# john2006168
¥H¸É¤½¦¡ ~~~~~~~
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 4# hcm19522

=IF((B4="")*(B5=""),"",F4&IF(B5="","","©M")&B5)
¤æ
IF((B4="")*(B5="")¬O¤°»ò·N«ä?¦pªG¤£¥Î¤U©Ô,¦³¨S¦³¦nªº¤èªk?

TOP

        ÀR«ä¦Û¦b : ¤ß¤¤±`¦sµ½¸Ñ¡B¥]®e¡B·P«ä¡Bª¾¨¬¡B±¤ºÖ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD