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

if¤½¦¡,¤½¦¡¨S¿ùªü,¬°Ô£µ²½×·|¿ù?

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

¦^´_ 1# ricky08240920

=IF(ISNUMBER(MATCH(B2,$A$1:$A$5,0)),"y","n")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 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

TOP

¦^´_ 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§A­nªºµ²ª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¤½¦¡

TOP

¦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¤½¦¡

TOP

¦^´_ 5# ML089


   ¨ü±Ð¤F...ÁÂÁÂ!

TOP

¨ü±Ð¤F...ÁÂÁÂ!
rrriiiccckkkyyy

TOP

        ÀR«ä¦Û¦b : ¤Ó¶§¥ú¤j¡B¤÷¥À®¦¤j¡B§g¤l¶q¤j¡A¤p¤H®ð¤j¡C
ªð¦^¦Cªí ¤W¤@¥DÃD