In a hurry?

Read this coding fable from Better Software Magazine.

Second Test

I figure now is as good a time as any to try my second test. 

 

  • I add in the test 2 = “II” and copy the C and D formulas from the existing row 


So, now I have my 2nd test and it is failing.  It might not feel like it, but this is good.  Very good!

It’s the rhythm of TDD – write a failing test, make it work using the simplest way possible, then refactor (i.e. tidy up) the code.

 

I reckon I know how to fix up this code.

 

  • After a quick peek in the Excel help files on the “if” statement, I change the code
Public Function i2r(i As Integer) As String

application.volatile

If i = 1 Then

    i2r = "I

Else

    i2r = "II

End If

End Function
 

  • Then I switch across to Excel and press F9 to recalculate.

 

Two passing tests!  I’m on a roll.  Now, let's add some more tests.

Comments