- ©«¤l
- 71
- ¥DÃD
- 16
- ºëµØ
- 0
- ¿n¤À
- 111
- ÂI¦W
- 221
- §@·~¨t²Î
- Windows 10
- ³nÅ骩¥»
- Office 2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-3-7
- ³Ì«áµn¿ý
- 2024-11-3
|
¦³¤@Ó 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 |
|