Each new term in the Fibonacci sequence is generated by adding the previous two terms. By starting with 1 and 2, the first 10 terms will be:
1, 2, 3, 5, 8, 13, 21, 34, 55, 89, ...
Find the sum of all the even-valued terms in the sequence which do not exceed four million.my solution;
Sub Euler2()
Dim first, second, temp, sum, limit
first = 1
second = 1
sum = 0
limit = 4000000
Do While second < limit
If second Mod 2 = 0 Then
sum = sum + second
End If
'ActiveCell.Value = second
'ActiveCell.Offset(1, 0).Activate
temp = first + second
first = second
second = temp
Loop
MsgBox (sum)
End Sub
Dim first, second, temp, sum, limit
first = 1
second = 1
sum = 0
limit = 4000000
Do While second < limit
If second Mod 2 = 0 Then
sum = sum + second
End If
'ActiveCell.Value = second
'ActiveCell.Offset(1, 0).Activate
temp = first + second
first = second
second = temp
Loop
MsgBox (sum)
End Sub
댓글 없음:
댓글 쓰기