for next time in Codecademy, in Functions,
"Defining Functions"
codecademy
Sub foo()
I = 0
While I <= 4
Debug.Print "I is now " & I
I = I + 1
Wend
End Sub
Sub bar()
I = 1
Do
Debug.Print "I is now " & I
I = I + 1
Loop While I < 5
End Sub
isLeap?
if divisible by 4: is leap
except, if divisible by 100, not leap year
except, if divisible by 400, is leap
=IF(MOD(A41, 400)=0, "leap", IF(MOD(A41, 100)=0, "not leap", IF(MOD(A41, 4)=0, "leap", "not leap")))
HW: Try writing an IsLeap function in VBA
contine with dates and times
hopefully finish ch 6 today (Formulas book)
No comments:
Post a Comment