Dim Total(858) As Long
Public Sub Main()
Total(0) = 2
For x = 499 To 0 Step -1
For i = UBound(Total) - 3 To LBound(Total) Step -1
Total(i) = Total(i) * (250000 - x * x)
Total(i + 1) = Total(i + 1) + Total(i) \ 1000
Total(i) = Total(i) Mod 1000
Total(i + 2) = Total(i + 2) + Total(i + 1) \ 1000
Total(i + 1) = Total(i + 1) Mod 1000
Total(i + 3) = Total(i + 3) + Total(i + 2) \ 1000
Total(i + 2) = Total(i + 2) Mod 1000
Next i
Next x
For i = UBound(Total) - 3 To LBound(Total) + 1 Step -1
Debug.Print Format(Total(i), "000") & ",";
Next i
Debug.Print Format(Total(0), "000")
End Sub
以下是引用LucasLynn在2005-8-3 11:48:00的发言:
Dim Total(858) As Long
Public Sub Main()
Total(0) = 2
For x = 499 To 0 Step -1
For i = UBound(Total) - 3 To LBound(Total) Step -1
Total(i) = Total(i) * (250000 - x * x)
Total(i + 1) = Total(i + 1) + Total(i) \ 1000
Total(i) = Total(i) Mod 1000
Total(i + 2) = Total(i + 2) + Total(i + 1) \ 1000
Total(i + 1) = Total(i + 1) Mod 1000
Total(i + 3) = Total(i + 3) + Total(i + 2) \ 1000
Total(i + 2) = Total(i + 2) Mod 1000
Next i
Next x
For i = UBound(Total) - 3 To LBound(Total) + 1 Step -1
Debug.Print Format(Total(i), "000") & ",";
Next i
Debug.Print Format(Total(0), "000")
End Sub
看不懂,是什麼思路來的。
欢迎光临 Office中国论坛/Access中国论坛 (http://www.office-cn.net/) | Powered by Discuz! X3.3 |