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

excel ¤½¦¡Â²¤Æ

excel ¤½¦¡Â²¤Æ

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

¦^´_ 4# hcm19522

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

TOP

¦^´_ 3# john2006168
¥H¸É¤½¦¡ ~~~~~~~
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 2# hcm19522

¬Ý¤£¨ì

TOP

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

        ÀR«ä¦Û¦b : ¤â¤ß¦V¤U¬O§U¤H¡A¤â¤ß¦V¤W¬O¨D¤H¡F§U¤H§Ö¼Ö¡A¨D¤Hµh­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD