[Chicago] VBA sucks (or is it Excel?)

[Kenneth P. Stox]

On Wed, 2008-04-30 at 17:53 -0400, rcriii at ramsdells.net wrote:
> >From the VBA immediate window:
> 
> print InRange(row, Col)
>  39543.4993171296
> print searchval
>  39543.5
> print InRange(row, Col) >= SearchVal
> True
> print 39543.4993171296 >= 39543.5
> False
> 
> I know this isn't python, but I had to share.

Microsoft has had consistent problems with rounding since their first
product for the IBM-PC. For those who missed it, or were silly enough
not to be born yet, in PC-DOS 1.0, the PC-Basic interpreter would report
that 1 + 1 = 1.99999. PC-DOS 1.1 was rushed out the door just a few
weeks later with a new version of the Basic interpreter. VBA is
descendant of that codebase. Some things never change.