- ©«¤l
- 1572
- ¥DÃD
- 16
- ºëµØ
- 2
- ¿n¤À
- 1521
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2016-1-13
|
¥»©«³Ì«á¥Ñ oobird ©ó 2011-8-4 23:23 ½s¿è
¦^´_ 3# eric866
³oÓº¡¶Ë¸£µ¬ªº¡A¥Î¦Ûq¨ç¼Æ§a¡C- Function Calculat(rng As Range) As Double
- a = rng.Cells.Count
- If rng(a) > 0 Then
- Calculat = 1
- Do
- a = a - 1
- If rng(a) > 0 Then Calculat = Calculat + 1
- Loop Until rng(a) < 0 Or a = 1
- Else
- Calculat = -1
- Do
- a = a - 1
- If rng(a) < 0 Then Calculat = Calculat - 1
- Loop Until rng(a) > 0 or a=1
- End If
- End Function
½Æ»s¥N½X
|
|