EXCEL ¤½¦¡ ¥ÎEXCEL ¨ç¼ÆÅã¥ÜªÅ¥Õ
- ©«¤l
- 25
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 35
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- S
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2014-2-19
- ³Ì«áµn¿ý
- 2016-2-24
|
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 |
|
|
|
|
|
|
- ©«¤l
- 19
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 57
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2015-3-8
- ³Ì«áµn¿ý
- 2016-12-27
|
IF(ISBLANK(A1),"",n°µªº¹Bºâ))
¬Ý¤£¤ÓÀ´ÃD·N |
|
|
|
|
|
|
- ©«¤l
- 161
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 168
- ÂI¦W
- 0
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-9-16
- ³Ì«áµn¿ý
- 2017-2-19
|
¦^´_ 1# iwiniwin
§PÂ_ªÅ¥Õ, ¸Õ¸Õ :
=IF(OR(A1=0,CLEAN(A1)=""),"","¤½¦¡") |
|
|
|
|
|
|