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

EXCEL ¤½¦¡ ¥ÎEXCEL ¨ç¼ÆÅã¥ÜªÅ¥Õ

EXCEL ¤½¦¡ ¥ÎEXCEL ¨ç¼ÆÅã¥ÜªÅ¥Õ

Ãö©ó Àx¦s®æÅã¥Ü¤½¦¡  ¦ý¬O§ì¨ì­È¬OªÅ¥Õªº
¦b¥t¤@­ÓÀx¦s®æ§Ú­n§P©w¥¦¬O¤½¦¡ªÅ¥Õ   §Ú´NÅý¦oÅã¥ÜªÅ¥Õ   ¦pªG¦³­È¦b°µ¨ä¥L¹Bºâ

½Ð°Ý¤@¤U ³o¦³¿ìªk¥ÎEXCEL¨ç¼Æ§ï¼g¶Ü?
°²³]

A1  SHEET ¥h§ì  SHEET2   A1  ªº­È

=SHEET2!A1  Àx¦s®æA1¦³¤½¦¡
¨º§Ú·Q¦bB  ¥h§P©w  IF(A1="","",¥¿±`)
¦ý¬O¥d¦b¬O¤½¦¡§PÂ_ªÅ¥Õ·|¦³°ÝÃD

IF(ISBLANK(A1),"",­n°µªº¹Bºâ))
¬Ý¤£¤ÓÀ´ÃD·N

TOP

¦^´_ 1# iwiniwin

§PÂ_ªÅ¥Õ, ¸Õ¸Õ :

=IF(OR(A1=0,CLEAN(A1)=""),"","¤½¦¡")

TOP

        ÀR«ä¦Û¦b : ¡i»X½ªªº¦Û¥Ñ¡j¤H±`¦b¤°»ò³£¥i¥H¦Û¥Ñ¦Û¦bªº®É­Ô¡A«o³Q³oºØÀH¤ß©Ò±ýªº¦Û¥Ñ»X½ª¡AµêÂY®É¥ú¦Ó²@µLıª¾¡C
ªð¦^¦Cªí ¤W¤@¥DÃD