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

if ¨ç¼Æ°ÝÃD

if ¨ç¼Æ°ÝÃD

§Ú·Q½Ð°Ý¤@¤U¡A¦pªG§Ú¦bA1Àx¦s®æ¬°100, B1Àx¦s®æ·Q¿é¤J">0"(¦¹®æ¬°Åܰʱø¥ó®æ)
¨º§Ú·Q¦bA3®æ¤¤¼g¤JÃþ¦ü =IF(A1 & B1 , "1","0")
§Ú¸Ó¦p¦ó²Õ¦¨³o¨â­ÓÀx¦s®æ¨ÓÆF¬¡³]©w§PÂ_¤j¤p

=IF(COUNTIF(A1, B1)=1 , "1","0")
OR
=COUNTIF(A1, B1)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089

ÁÂÁ¤j¤j³o»ò¨³³t¦a¦^´_¡A§Ú¦³¸Õ¥X¤@¨ÇªF¦è¤F!!
¤£¦n·N«ä¦A¥´ÂZ¤@¤U³á!!½Ð°Ý§ÚCOUNTIF(A1,B1)
¸Ì­±ªºA1 ¥i¥HÅܦ¨¦p¡GA1-A2ªº­pºâ¦¡¶Ü??
¨Ò¦p¡GCOUNTIF(A1-A2,B1)

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2014-9-25 17:05 ½s¿è

¦^´_ 3# lichang

COUNTIF(ref, ±ø¥ó)

ref ¥u¯à¬OÀx¦s®æ½d³ò¡A¤£¯à¨Ï¥Î A1-A2

A3 = A1-A2
=COUNTIF(A3, B1)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ­n¥Î¤ß¡A¤£­n¾Þ¤ß¡B·Ð¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD