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

[µo°Ý] ¤ñ¹ï¸ê®Æ°ÝÃD

[µo°Ý] ¤ñ¹ï¸ê®Æ°ÝÃD

½Ð°Ý
a1=1  a2=2  a3=3
b1=4  b2=5  b3=6   

·Q¦b c1   ¤ñ¹ï¤W­zÀxÂî椤¦³ 3©Î5  ¦bc1Åã¥Ü  ¬O ©Î §_  

À³¸Ó¥Î¬Æ»ò¤èªk©O
HI

=IF(SUM(COUNTIF(A1:B3,3),COUNTIF(A1:B3,5))>0,"¬O","§_")
¨S¨Æ´N¨Ó³}³}

TOP

¥»©«³Ì«á¥Ñ ANGELA ©ó 2011-2-25 10:35 ½s¿è

=IF(SUMPRODUCT((A1:B3={3,5})*1),"¬O","§_")
¥H¤W¬O¿ùªº
=IF(SUMPRODUCT((A1:B3=5)*1)+SUMPRODUCT((A1:B3=3)*1) ,"¬O","§_")
OR
=IF(COUNTIF(A1:B3,3)+COUNTIF(A1:B3,5),"¬O","§_")

TOP

·PÁ ANGELA fr447446 ¨â¦ì¤j¤j
§A­Ìªº«ü¥O¦h¥i¥H¥Î ÁÂÁÂ
HI

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD