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

[µo°Ý] Ãö©ó¦p¦óÅýIF²[¼Æ¤º±aªº"¤å¦r"¤£Åã¥Ü

[µo°Ý] Ãö©ó¦p¦óÅýIF²[¼Æ¤º±aªº"¤å¦r"¤£Åã¥Ü

½Ð°Ý¬OIFµLªk³o¼Ë¨Ï¥Î¶Ü?

EX:
=F40&CHAR(10)&C40&"("&H40&")"

¦pªG³£Àx¦s®æ³£µL¼Æ¾Ú ·|Åã¥Ü  ---> ()

=IF(F40&CHAR(10)&C40&"("&H40&")"="()","",F40&CHAR(10)&C40&"("&H40&")")   ---->>·|Åã¥ÜªÅ¥Õ <<¬O§Ú­nªº

¦ý¦pªGÀx¦s®æ¬O¸ó­¶ªº¸Ü´N¨S¦³®ÄªG...­ì¥»µL¸ó­¶¥iÅã¥Ü¬°ªÅ¥Õ,¦ý¸ó­¶´N³£¤@ª½Åã¥Ü¬° ---> ()

¦^´_ 1# starry1314


=IF(COUNTA(F40,C40,H40)=0,"",F40&CHAR(10)&C40&"("&H40&")")
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

·PÁª©¥D¡I¡I¡I¯u¬OÀ°¤F¤j¦£¡ã¤£µMªí®æ¯u¬OÁà

TOP

¥»©«³Ì«á¥Ñ starry1314 ©ó 2015-5-17 13:00 ½s¿è

¦^´_ 2# ML089

½Ð°Ýª©¥D¦pªG¹J¨ì³oºØª¬ªp¸Ó¦p¦ó¸Ñ¨M©O¡H

¥Ø«e¸ó­¶¥i¸Ñ¨MÅý¥LÅã¥Ü¬°ªÅ¥Õ  =IF(COUNTA(F40,C40,H40)=0,"",F40&CHAR(10)&C40&"("&H40&")")
¦ý¦pªG F40.C40.H40Àx¦s®æ¬°©w¸q¦WºÙ¥X¨Óªº¸ê®Æ,´N¤S¦^¨ì¤@¼Ëªºª¬ªp¤F¡I

TOP

¥»©«³Ì«á¥Ñ starry1314 ©ó 2015-5-17 17:13 ½s¿è

¦^´_ 2# ML089
¥Ø«e¥u¯à¥ý¥H®æ¦¡¤Æ±ø¥ó,³]¬°¥Õ¦â µø¦Ó¤£¨£.....

TOP

¦^´_ 4# starry1314


    À³¸Ó¬O©w¸q¦WºÙªº°ÝÃD¡A¤£ª¾§Aªº¦WºÙ¦p¦ó©w¸q
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ starry1314 ©ó 2015-5-17 18:23 ½s¿è

¦^´_ 6# ML089

¨Ò¤l:
'¼ÐÅҼƾÚ(¦­)'!$F:$F
'¼ÐÅҼƾÚ(¤È)'!$C:$C
'¼ÐÅҼƾÚ(±ß)'!$H:$H

¦]·|¥h§R°£¨ìÀx¦s®æ©Ò¥H¥Î©w¸q¦WºÙ(¾ãÄæ),§_«h¤@§R°£§Ú°Ñ·ÓªºÀx¦s®æ·|¥þ³£¸õ#RFF

TOP

¦^´_ 6# ML089
ªþ¤WÀÉ®×.......

½d¨Ò-IF ©w¸q¦WºÙµLªkÅã¥ÜªÅ¥Õ.rar (65.75 KB)

TOP

¦^´_ 8# starry1314

A2 =IF('¼ÐÅҼƾÚ(¦­À\)'!J2&'¼ÐÅҼƾÚ(¦­À\)'!K2&'¼ÐÅҼƾÚ(¦­À\)'!L2="","",'¼ÐÅҼƾÚ(¦­À\)'!J2&CHAR(10)&'¼ÐÅҼƾÚ(¦­À\)'!K2&"("&'¼ÐÅҼƾÚ(¦­À\)'!L2&")")

¦]¬°J K L¬°¤½¦¡¡AÁöµM¦^¶Ç""¦ý¹ïCOUNTA¨ç¼Æµø¬°¦³¸ê®Æ¤º®e
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 9# ML089


    ¤F¸Ñ~¨º§Ú¥u¦n¥ý¥Î®æ¦¡¤Æ¨Ó°µ³B²z¤F¡I·PÁÂ

TOP

        ÀR«ä¦Û¦b : ¤Ó¶§¥ú¤j¡B¤÷¥À®¦¤j¡B§g¤l¶q¤j¡A¤p¤H®ð¤j¡C
ªð¦^¦Cªí ¤W¤@¥DÃD