[µo°Ý]½Ð±Ð¥ý¶i excel vba 2¸ê®ÆÀx¦s®æ¤ñ¸û
- ©«¤l
- 38
- ¥DÃD
- 14
- ºëµØ
- 0
- ¿n¤À
- 58
- ÂI¦W
- 0
- §@·~¨t²Î
- win xp
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-5-22
- ³Ì«áµn¿ý
- 2020-3-9
|
[µo°Ý]½Ð±Ð¥ý¶i excel vba 2¸ê®ÆÀx¦s®æ¤ñ¸û
³]3¦U«ö¶s(¶}©l¶s.°±¤î¶s.ºò«æ¶s)
C6Àx¦s®æ³]©wÀË´úÀW²v(¨Ò¦p¿é¤J100 ´N¬O100»¨¬í ©Î500»¨¬í=0.5¬í ©Î1000»¨¬í=1¬í)
C5Àx¦s®æ»PC7Àx¦s®æ§@¤ñ¸û(Àx¦s®æ¸Ì±ªº¼Æ¦r¥u¦³1 0 -1)
1.«ö¤U ¶}©l¶s °Ê§@
C5>C7 ·|°õ¦æA¥¨¶°
C5<C7 ·|°õ¦æC¥¨¶°
C5>C7 ¥B C5=0 ·|°õ¦æA¥¨¶° B¥¨¶°
C5<C7 ¥B C5=0 ·|°õ¦æB¥¨¶° C¥¨¶°
C5=C7 (¤£°µ¥ô¦ó°Ê§@)
°£«D«ö¤U°±¤î¶s §_«h¤@ª½«½Æ°õ¦æ
2.«ö¤U °±¤î¶s °Ê§@
(¤@)¦pªGC5=C7=0 ´N°¨¤W°±¤î
(¤G)¦pªGC5=C7¤£µ¥©ó0
·|µ¥¨ìC5=C7=0 ¤~°±¤î
3.«ö¤U ºò«æ¶s °Ê§@
(¤@)C5>C7 °¨¤W°õ¦æA¥¨¶° B¥¨¶°
(¤G)C5<C7 °¨¤W°õ¦æB¥¨¶° C¥¨¶°
==================
½Ð±Ð¥ý¶i
¤Wz°Ê§@ªºVB½X n¦p¦ó¼¶¼g?? |
|
|
|
|
|
|