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

[µo°Ý] ­n¦p¦óµ¹¤©EXCEL¦h­Ó§PÂ_¦¡

[µo°Ý] ­n¦p¦óµ¹¤©EXCEL¦h­Ó§PÂ_¦¡

¤£¦n·N«ä¡A½Ð±Ð¦U¦ì«e½ú
TESTQ.rar (15.06 KB)
½Ð¬Ý§Úªºªþ¥ó  HÄæ¦ì¬O¥ÎIF¥h§PÂ_µ²ªG¡A¦ý¬O¤£°÷¥¿½T¡AÁٻݭnµøEÄ檺¤º®e¦Ó©w
¥d¦b³oÃä·Q¤£¨ì¸Ñµª¡A·Ð½Ð«e½ú¶}¥Ü¡AÁÂÁÂ

¦^´_ 1# abc9gad2016


=IF(LEN(E2)<>2,B2&"Y",B2)
¦V¤U½Æ»s

TOP

=IF(ISERROR(G2),B2&IF(LEN(E2)=2,"","Y"),G2)

TOP

=IF(ISERROR(G2),B2&IF(OR(E2={"ª½°e";"¦¨«~"}),"","Y"),G2)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

·PÁ¼ӤW´X¦ì¤j¤j¸òª©¥Dªº¸Ñµª~
¯S§O­nÁÂÁª©¥D¡A³o¼Ë§ÚEÄ椺®e¦³ÅܤƤ]¥i¥Hª½±µ¥h­×§ï¡A¤£·|³Q¦r¼Æ­­¨î
·PÁ¦U¦ì«e½ú

TOP

¦^´_ 4# ML089


    ½Ð°Ýª©¥D¡A³o­Ó¤º®e¬°¤°»ò¬A¸¹­n¥Î{}¡A¤£¾å±o³o¬O¤°»ò·N«ä(¦L¶H¤¤¬O°}¦C?) ÁÂÁÂ
{"ª½°e";"¦¨«~"}

TOP

¦^´_ 6# abc9gad2016

¬O°}¦C {"ª½°e";"¦¨«~"}
¥H ; ¤À¶}®É¬°««ª½°}¦C
¥H , ¤À¶}®É¬°¤ô¥­°}¦C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¤H¨ÆªºÁ}Ãø»PµZ¿i¡A´N¬O¤@ºØ¦ÒÅç¡C
ªð¦^¦Cªí ¤W¤@¥DÃD