VB Forum / COM / October 2007

Can someone solve the following puzzle for me? I ran across this in one
of my projects and can't believe this is how VB works. Somehow VB thinks
that 8.62 * 100 <> 862. I have a work-around but really would like to
know why this doesn't work.

Private Sub Form_Load()
 Dim Amt1 As Double
 Dim Amt2 As Double
 Dim Amt3 As Double

 Amt1 = 862
 Amt2 = 8.62
 
 Amt3 = Amt2 * 100

 If Amt1 <> Amt3 Then
   MsgBox ("All is lost")
 End If

 If Amt1 = Amt2 Then
   MsgBox ("All is right with the world")
 End If
End Sub