Tuesday, February 28, 2012


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