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

[µo°Ý] [¨D±Ð]¦p¦ó¯à§Q¥Î¨ç¼Æ©ÎªÌµ{¦¡¶ñ¸É¨â¸ê®ÆÀx¦s®æ¤¤¤§ªÅ¥Õ

[µo°Ý] [¨D±Ð]¦p¦ó¯à§Q¥Î¨ç¼Æ©ÎªÌµ{¦¡¶ñ¸É¨â¸ê®ÆÀx¦s®æ¤¤¤§ªÅ¥Õ

½Ð±Ð¦U¦ì¥ý¶i¡G
    ¦p½d¨Ò¤¤¡A¨â¤é´ÁÄæ¦ì¤¤¶¡¦³ªÅ¥Õ(ªÅ¥Õ¶¡¹j¤£¤@)¡A·Q­n±NªÅ¥Õ³B¶ñº¡¤W­±Àx¦s®æ¤§¤é´Á¡A¤£ª¾¬O§_¦³¨ç¼Æ¥i¥H¸Ñ¨MÁÙ¬O¤@©w­n¸g¥ÑVBAµ{¦¡§¹¦¨¡C
¤£ª¾¬O§_¥i¥H´£¨Ñ¨ç¼Æ¼gªk©ÎªÌµ{¦¡¼gªk¡I ¤é´Á¶¡¶ñº¡½d¨Ò.rar (4.14 KB)

¦³¤@­Ó IsBlank ªº¨ç¼Æ...

=if(isblank(A1) = True, "-",A1)

TOP

¦³¤@­Ó IsBlank ªº¨ç¼Æ...

=if(isblank(A1) = True, "-",A1)
vanguarx µoªí©ó 2015-3-27 16:31



ÁÂÁ±zªºÀ°¦£¡I

¦ý¬O³o¥u¯à§ä¨ì¦³¤é´ÁªºÀx¦s®æ¡A§Ú§Æ±æªº¬O±N¨â¦³¤é´ÁÀx¦s®æ¤§¶¡ªºªÅ¥ÕÀx¦s®æ¶ñ¤J³o¨ÇÀx¦s®æªº¤W¤è¤é´Á (¸Ô¨£½d¨Ò  ´N¬Oµ¥¦P±N²Ä¤@­ÓÀx¦s®æ©¹¤U½Æ»s¶ñº¡ªÅ¥ÕÀx¦s®æ)¡A¦ý²{¦b¦]¬°¨C­Ó¦³¤é´Á¸ê®Æ¤§¶¡ªºªÅ¥ÕÀx¦s®æ¨Ã¨S¦³³W«h¡A©Ò¥H»Ý­n¦³­Ó¤è¦¡ (¨ç¼Æ©ÎªÌ¬OVBAµ{¦¡) ¥i¥H¸Ñ¨M³o­Ó°ÝÃD¡A¦]¬°¸ê®Æµ§¼Æ¦h¡I

TOP

·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 4# GBKEE


    ·PÁª©¥D¤À¨É¡A³o¥¿¬O§Ú·Q­nªº¥\¯à¡I¦A¦¸ÁÂÁ¡I

TOP

        ÀR«ä¦Û¦b : ¥¬¬I¦p¼½ºØ¡A¥HÅw³ß¤ß´þ¼íºØ¤l¡A¤~·|µoªÞ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD