¦p¦óÅýEXCEL¤À¿ì©Îpºâ¥X¦P¤@Ä椺ªº´XÓ¼ÆÈ
- ©«¤l
- 2
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 3
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2014-11-4
- ³Ì«áµn¿ý
- 2014-11-4
|
¦p¦óÅýEXCEL¤À¿ì©Îpºâ¥X¦P¤@Ä椺ªº´XÓ¼ÆÈ
¦U¦ì°ª¤â, ¥i¥HÀ°¦£¤@¤U, ¦p¦óÅýEXCEL¤À¿ì©Îpºâ¥X¦P¤@Ä椺ªº´XÓ¼ÆÈ, ¨Ò¦p¤À¿ì©Îpºâ¥X¦P¤@Ä椤´XÓ¼ÆȤºªºÁ`©M¬O§_100%, ÁÂÁ |
|
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
¨CÓ¼Æȳ£¦³ %¡A©Ò¥Hp꿦³´XÓ%´N¯àª¾¹D¦³´XÓ¼ÆÈ
=SUMPRODUCT(LEN(SUBSTITUTE(A2:A15,{"","%"},))*{1,-1}) |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 2
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 3
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2014-11-4
- ³Ì«áµn¿ý
- 2014-11-4
|
ÁÂÁª©¥D¸Ñµª
¥t¥~¥Ñ©ó¨C¦æ³£¥]§t¤å¦r, ¦³¤èªk¯à¤À§O¥X¨C¤@¦æªº¦Ê¥÷¤ñ¬O§_100% ©ÎªÌ¤Ö©ó100%¶Ü? |
|
|
|
|
|
|
- ©«¤l
- 77
- ¥DÃD
- 11
- ºëµØ
- 0
- ¿n¤À
- 96
- ÂI¦W
- 0
- §@·~¨t²Î
- windows xp
- ³nÅ骩¥»
- OFFICE 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2012-8-29
- ³Ì«áµn¿ý
- 2023-10-30
|
½Ð°Ý¥i¤£¥i¥H¥Î«á±ªºcolumn¨Ópºâ¶Ü... |
|
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
¥»©«³Ì«á¥Ñ ML089 ©ó 2014-11-6 11:50 ½s¿è
¦^´_ 3# lamlamboy
¥t¥~¥Ñ©ó¨C¦æ³£¥]§t¤å¦r, ¦³¤èªk¯à¤À§O¥X¨C¤@¦æªº¦Ê¥÷¤ñ¬O§_100% ©ÎªÌ¤Ö©ó100%¶Ü?
²Îp¦³¦h¤ÖÓ 100%
C2 =COUNTIF(A:A, "*100%*")
Y¬O¨C¦Cpºâ
B2=IF(COUNTIF(A2, "*100%*"), "Y", "N")
¨Ì½d¨Ò 100%³£¦b³Ì¥ªÃä
B2 =IF(LEFT(A2)="100%", "Y", "N") |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 77
- ¥DÃD
- 11
- ºëµØ
- 0
- ¿n¤À
- 96
- ÂI¦W
- 0
- §@·~¨t²Î
- windows xp
- ³nÅ骩¥»
- OFFICE 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2012-8-29
- ³Ì«áµn¿ý
- 2023-10-30
|
¦^´_ 5# ML089
¦ý°ÝÃD¬O¨CÓCELL¸Ì±¦³¤@өΨâÓ%.. n«ç¤~¥i¥H§ä¥X¨Ãpºâ¨CÓCELLªºÁ`¼Æ©O.. |
|
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
¦^´_ 6# jomeow
½Ð°Ñ¦Ò 2#ªº¤èªk |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 976
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 1018
- ÂI¦W
- 0
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office 2016
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-4-19
- ³Ì«áµn¿ý
- 2024-10-30
|
¦^´_ 7# ML089
ÂǥѦ¹ÃD½Ð°Ýª©¥D¦pªþ¥óB2 ªº¤½¦¡¬°¦ó? |
-
-
test.png
(22.42 KB)
|
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
¦^´_ 8# samwang
¥i¥H§Q¥ÎªÅ®æ±N¼Æ¦r ¤ÀÂ÷ - ¨ú¥X - ¦Xp
=SUMPRODUCT(--TEXT(MID(SUBSTITUTE(A2," ",REPT(" ",99)),ROW($1:$9)*99-98,99),"[<>];!0;!0;!0")) |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 976
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 1018
- ÂI¦W
- 0
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office 2016
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-4-19
- ³Ì«áµn¿ý
- 2024-10-30
|
¦^´_ 9# ML089
ÁÂÁ¡A¦A½Ð°Ý
1. TEXT( value, format_text) >> format_text "[<>];!0;!0;!0" ¬O¦p¦ó³]©w¦³µL¥i°Ñ·Ó
{"abc ";" 30% ";" aabbcc ";" 50%";"";"";"";"";"";"";""}
{"0";"0.3";"0";"0.5";"0";"0";"0";"0";"0";"0";"0"} |
|
|
|
|
|
|