if¤½¦¡,¤½¦¡¨S¿ùªü,¬°Ô£µ²½×·|¿ù?
- ©«¤l
- 8
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 18
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-6-25
- ³Ì«áµn¿ý
- 2015-4-6
|
if¤½¦¡,¤½¦¡¨S¿ùªü,¬°Ô£µ²½×·|¿ù?
1.rar (6.09 KB)
a b =IF(B2=$A$1:$A$5,"y","n")
b
c
d
e
¤½¦¡À³¸Ó¨S°ÝÃDªü?..¬°Ô£¥X²{"n"....
thank you |
|
rrriiiccckkkyyy
|
|
|
|
|
- ©«¤l
- 8
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 18
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-6-25
- ³Ì«áµn¿ý
- 2015-4-6
|
|
rrriiiccckkkyyy
|
|
|
|
|
- ©«¤l
- 1
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 2
- ÂI¦W
- 0
- §@·~¨t²Î
- win 7
- ³nÅ骩¥»
- office 2010
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2014-5-15
- ³Ì«áµn¿ý
- 2014-9-16
|
¦^´_ 5# ML089
¨ü±Ð¤F...ÁÂÁÂ! |
|
|
|
|
|
|
- ©«¤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
|
¦n¯«©_,countif¶Ç¦^¬°¼Æ¦r«D¥¬ªLÈ,±a¨ìif¨ç¼Æ«o¥i¥Î...¤£À´«u.
hsieh716 µoªí©ó 2014-5-16 14:26
¼ÆÈ°µ¬°IFªº§PÂ_È®É
0 ¬° FALSE
¨ä¥LȬ° TRUE |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤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
|
¦^´_ 1# ricky08240920
즡³oºØ¼gªk¬O¿ù»~ªº
=IF(B2=$A$1:$A$5,"y","n")
B2»P$A$1:$A$5¤ñ¸û¦³5ºØµ²ªG¡A¤@¯ë·|¥[¤WOR©ÎAND§ó©ú½T©w¸q§Anªºµ²ªG¡A¦p¤U¦¡
=IF(OR(B2=$A$1:$A$5),"y","n")
¦¹Ãþ¤½¦¡¬°°}¦C¤½¦¡»Ýn¥Î CTRL+SHIFT+ENTER¤TÁä»ô«ö¤è¦¡¿é¤J¤½¦¡
Y¬O =IF(OR(B2=$A$1:$A$5),"y","n") ³oºØ°}¦C¤½¦¡¡A¤]¥i¥H¥ÎCOUNTIF¨ç¼Æ¨Ó´À¥N¡A´N¤£¥Î°}¦C¤½¦¡¿é¤J¨º»ò³Â·Ð¡C
=IF(COUNTIF($A$1:$A$5,B2),"y","n") |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 129
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 178
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-12-28
- ³Ì«áµn¿ý
- 2018-11-10
|
¦^´_ 1# ricky08240920
IF(B2=$A$1:$A$5,"y","n")
¦pªG§A§âA2 §ï¦¨a C2´N·|Åܦ¨y
¦pªG§A§âA3 §ï¦¨b C3´NÅܦ¨y
±À½×ÁöµM§AC2¤½¦¡¬O¼gB2=A1:A5 , ¦ý¬O¥L¹ê»Ú¬O ®Ú¾Ú§A¦bC2ªº¦ì¸m Åܦ¨¥h§PÂ_B2=A2
¦P²zC3ªº¤½¦¡´N·|Åܦ¨B3=A3
¥i¥H¥Î countif , sumproduct, match , lookup¥h³B²z... ¦b»²§Uisnumber or if... ¥h§PÂ_ |
|
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X
|
|
|
|
|