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

½Ð°Ý¥i¨Ï¥Î¦óºØ¤èªk²Î­p¦@¦³´X­ÓÀx¦s®æ¦³¼ÐÃC¦â?

½Ð°Ý¥i¨Ï¥Î¦óºØ¤èªk²Î­p¦@¦³´X­ÓÀx¦s®æ¦³¼ÐÃC¦â?

¤j®a¦n

½Ð°Ý¥i¨Ï¥Î¦óºØ¤èªk²Î­p¦@¦³´X­ÓÀx¦s®æ¦³¼ÐÃC¦â?


ÁÂÁÂ

²Î­pÀx¦s®æ.zip (6.42 KB)

¦^´_ 5# chen890708

¤£¬O³£OK¤F

¦p2¼Ó©Ò­z
B2³]©w®æ¦¡¤Æ±ø¥ó  =OR(AND(A2=0,B2<>0),AND(A2>0,B2<=0),AND(A2<0,B2=0))
B2½Æ»s®æ¦¡¨ìB3~B9

B16=SUMPRODUCT((($A$2:$A$9)*($B$2:$B$9)<=0)*1)-SUMPRODUCT(($A$2:$A$9=0)*($B$2:$B$9=0))


¤£¤F¸ÑÁÙ¦³¤°»ò°ÝÃD?

TOP

¦^´_ 4# register313

     ÁÂÁ§A
  
      ¦¨¥\¤F

    ¥i¬O¦pªG­n¥HÃC¦â§PÂ_Àx¦s®æ¼Æ¶q¦³¤èªk¶Ü?

    ¥­®Éªº¸ê®Æ¦³¤W¤dµ§,¥u¬O·Qª¾¹D³o¨Ç¸ê®Æ¦³µL­t¼Æ©Î¦³¼Æ¶qµLª÷ÃBª¬ªp,¦pªG¥i¥H¥[Á`¦³ÃC¦âÀx¦s®æ,§Ú´Nª¾¹D¸ê®Æ¤¤¦³³oºØ±¡§Î,¥h°µ­×¥¿

     ¤£¥Î¨C¤@¦æ³£¥h¬d¸ß½T»{

     ÁÂÁÂ

TOP

¦^´_ 3# chen890708

A3Àx¦s®æ¤§¤½¦¡³y¦¨´`Àô°Ñ·Ó(A3=-A3)
§âA3=0  => B16¤§¤½¦¡§Y¥¿½T

TOP

¦^´_ 2# register313


    ÁÂÁ§A

    ¥i¬O§Ú¸Õ¤F§Aªº¤½¦¡¦ý¬O¨S¦³¥Î

    ¥­®Éªº¸ê®Æ¦³¤W¤dµ§,¥u¬O·Qª¾¹D³o¨Ç¸ê®Æ¦³µL­t¼Æ©Î¦³¼Æ¶qµLª÷ÃBª¬ªp,¦pªG¥i¥H¥[Á`¦³ÃC¦âÀx¦s®æ,§Ú´Nª¾¹D¸ê®Æ¤¤¦³³oºØ±¡§Î,¥h°µ­×¥¿

     ¤£¥Î¨C¤@¦æ³£¥h¬d¸ß½T»{

     ÁÂÁÂ

TOP

¦^´_ 1# chen890708

¤£¤Ó²M·¡§A³]©wÃC¦â¤§±ø¥ó¬°¦ó? ¥ý¸Õ¸Õ¬Ý

B2³]©w®æ¦¡¤Æ±ø¥ó  =OR(AND(A2=0,B2<>0),AND(A2>0,B2<=0),AND(A2<0,B2=0))
B2½Æ»s®æ¦¡¨ìB3~B9

B16=SUMPRODUCT((($A$2:$A$9)*($B$2:$B$9)<=0)*1)-SUMPRODUCT(($A$2:$A$9=0)*($B$2:$B$9=0))

TOP

        ÀR«ä¦Û¦b : ¹ï¤÷¥À­nª¾®¦¡A·P®¦¡B³ø®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD