ªð¦^¦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

¦^´_ 1# iwiniwin

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

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

TOP

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

TOP

        ÀR«ä¦Û¦b : ¡i°±º¢¤£«e¡A²×µL©Ò±o¡j¤H³£°g©ó´M§ä©_ÂÝ¡A¦]¦Ó°±º¢¤£«e¡FÁa¨Ï®É¶¡¦A¦h¡B¸ô¦Aªø¡A¤]¤FµL¥Î³B¡A²×µL©Ò±o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD