7,762
社区成员
发帖
与我相关
我的任务
分享
n = 14
for i = 2011 to 10000
n = n * 1.01
if (n >= 20) then
msgbox i
exit for
end
next
Private Sub Form_Load()
Debug.Print "年数="; Log(20# / 14#) / Log(1.01)
End Sub
Private Sub Form_Load()
Dim i As Integer
a = 14: b = 20
Do While Not a > b
a = a * (1 + 0.01)
i = i + 1
Loop
Debug.Print i
Debug.Print a
End Sub
Private Sub Form_Load()
Dim i As Integer
a = 14: b = 40
Do While Not a > b
a = a * (1 + 0.1)
i = i + 1
Loop
Debug.Print i
Debug.Print a
End Sub