½Ð°Ý¥i¨Ï¥Î¦óºØ¤èªk²Îp¦@¦³´XÓÀx¦s®æ¦³¼ÐÃC¦â?
- ©«¤l
- 18
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 30
- ÂI¦W
- 0
- §@·~¨t²Î
- window7
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-11-13
- ³Ì«áµn¿ý
- 2012-10-17
|
½Ð°Ý¥i¨Ï¥Î¦óºØ¤èªk²Îp¦@¦³´XÓÀx¦s®æ¦³¼ÐÃC¦â?
¤j®a¦n
½Ð°Ý¥i¨Ï¥Î¦óºØ¤èªk²Îp¦@¦³´XÓÀx¦s®æ¦³¼ÐÃC¦â?
ÁÂÁÂ |
|
|
|
|
|
|
- ©«¤l
- 967
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 1001
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN XP
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-11-29
- ³Ì«áµn¿ý
- 2022-5-17
|
¦^´_ 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? |
|
|
|
|
|
|
- ©«¤l
- 18
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 30
- ÂI¦W
- 0
- §@·~¨t²Î
- window7
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-11-13
- ³Ì«áµn¿ý
- 2012-10-17
|
¦^´_ 4# register313
ÁÂÁ§A
¦¨¥\¤F
¥i¬O¦pªGn¥HÃC¦â§PÂ_Àx¦s®æ¼Æ¶q¦³¤èªk¶Ü?
¥®Éªº¸ê®Æ¦³¤W¤dµ§,¥u¬O·Qª¾¹D³o¨Ç¸ê®Æ¦³µLt¼Æ©Î¦³¼Æ¶qµLª÷ÃBª¬ªp,¦pªG¥i¥H¥[Á`¦³ÃC¦âÀx¦s®æ,§Ú´Nª¾¹D¸ê®Æ¤¤¦³³oºØ±¡§Î,¥h°µ×¥¿
¤£¥Î¨C¤@¦æ³£¥h¬d¸ß½T»{
ÁÂÁÂ |
|
|
|
|
|
|
- ©«¤l
- 967
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 1001
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN XP
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-11-29
- ³Ì«áµn¿ý
- 2022-5-17
|
¦^´_ 3# chen890708
A3Àx¦s®æ¤§¤½¦¡³y¦¨´`Àô°Ñ·Ó(A3=-A3)
§âA3=0 => B16¤§¤½¦¡§Y¥¿½T |
|
|
|
|
|
|
- ©«¤l
- 18
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 30
- ÂI¦W
- 0
- §@·~¨t²Î
- window7
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-11-13
- ³Ì«áµn¿ý
- 2012-10-17
|
¦^´_ 2# register313
ÁÂÁ§A
¥i¬O§Ú¸Õ¤F§Aªº¤½¦¡¦ý¬O¨S¦³¥Î
¥®Éªº¸ê®Æ¦³¤W¤dµ§,¥u¬O·Qª¾¹D³o¨Ç¸ê®Æ¦³µLt¼Æ©Î¦³¼Æ¶qµLª÷ÃBª¬ªp,¦pªG¥i¥H¥[Á`¦³ÃC¦âÀx¦s®æ,§Ú´Nª¾¹D¸ê®Æ¤¤¦³³oºØ±¡§Î,¥h°µ×¥¿
¤£¥Î¨C¤@¦æ³£¥h¬d¸ß½T»{
ÁÂÁÂ |
|
|
|
|
|
|
- ©«¤l
- 967
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 1001
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN XP
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-11-29
- ³Ì«áµn¿ý
- 2022-5-17
|
¦^´_ 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)) |
|
|
|
|
|
|