Private Sub FloorVerify()
' Test the Floor function.
' Precision = .5
Debug.Assert Floor(1.4, 0.5) = 1
Debug.Assert Floor(1.1, 0.5) = 1
Debug.Assert Floor(1, 0.5) = 1
Debug.Assert Floor(0.9, 0.5) = 0.5
Debug.Assert Floor(0.6, 0.5) = 0.5
Debug.Assert Floor(0.5, 0.5) = 0.5
Debug.Assert Floor(0.4, 0.5) = 0
Debug.Assert Floor(0.1, 0.5) = 0
Debug.Assert Floor(0, 0.5) = 0
Debug.Assert Floor(-0.1, 0.5) = -0.5
Debug.Assert Floor(-0.4, 0.5) = -0.5
Debug.Assert Floor(-0.5, 0.5) = -0.5
Debug.Assert Floor(-0.6, 0.5) = -1
Debug.Assert Floor(-0.9, 0.5) = -1
Debug.Assert Floor(-1, 0.5) = -1
Debug.Assert Floor(-1.1, 0.5) = -1.5
Debug.Assert Floor(-1.4, 0.5) = -1.5
' Precision = 1
Debug.Assert Floor(2.9) = 2
Debug.Assert Floor(2.1) = 2
Debug.Assert Floor(2) = 2
Debug.Assert Floor(1.9) = 1
Debug.Assert Floor(1.1) = 1
Debug.Assert Floor(1) = 1
Debug.Assert Floor(0.9) = 0
Debug.Assert Floor(0.1) = 0
Debug.Assert Floor(0) = 0
Debug.Assert Floor(-0.1) = -1
Debug.Assert Floor(-0.9) = -1
Debug.Assert Floor(-1) = -1
Debug.Assert Floor(-1.1) = -2
Debug.Assert Floor(-1.9) = -2
Debug.Assert Floor(-2) = -2
Debug.Assert Floor(-2.1) = -3
Debug.Assert Floor(-2.9) = -3
' Precision = 2
Debug.Assert Floor(5.9, 2) = 4
Debug.Assert Floor(4.1, 2) = 4
Debug.Assert Floor(4, 2) = 4
Debug.Assert Floor(3.9, 2) = 2
Debug.Assert Floor(2.1, 2) = 2
Debug.Assert Floor(2, 2) = 2
Debug.Assert Floor(1.9, 2) = 0
Debug.Assert Floor(0.1, 2) = 0
Debug.Assert Floor(0, 2) = 0
Debug.Assert Floor(-0.1, 2) = -2
Debug.Assert Floor(-1.9, 2) = -2
Debug.Assert Floor(-2, 2) = -2
Debug.Assert Floor(-2.1, 2) = -4
Debug.Assert Floor(-3.9, 2) = -4
Debug.Assert Floor(-4, 2) = -4
Debug.Assert Floor(-4.1, 2) = -6
Debug.Assert Floor(-5.9, 2) = -6
' Other
Debug.Assert IsNull(Floor(Null))
Debug.Assert IsNull(Floor("Joe"))
Debug.Assert Floor(2.9, Null) = 2
Debug.Assert Floor(2.9, "Joe") = 2
End SubCopyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.