ªð¦^¦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 : «H¤ß¡B¼Ý¤O¡B«i®ð¤TªÌ¨ã³Æ¡A«h¤Ñ¤U¨S¦³°µ¤£¦¨ªº¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD