The following code fragment unexpectedly produces the value 17,236,000 for n. Could this be a bug?
Public a As Long = 17235999, b As Long = 17235031, n As Long
n = IIF(1, a, b)
It seems very much like the long values are being converted to floats and back.
Is there a volunteer who can confirm this behavior?
This post is under review.