Hi,

I feel a bit embarrssed to ask this one. But nonetheless it has out-foxed me...

I have 2 variables (both 'double' data types), where one value is subtracted from the other.

When I perform the sum of 3.63 - 3.57 at run-time or in the immediate window I get an incorrect result of '6.00000000000001E-02', whereas I'm expecting '0.06'

I have tried wrappng the Val and CDbl functions around the variables
(For example: Val(dblA) - Val(dblB))
- but I'm still not getting the same result.

Note
If I choose the '+' or '*' or '/' operators, I get the appropriate result in each case.

Any ideas?

Thanks in advance,

__________________
Neal

A Northern Soul

There are work around options for this problem like declaring the precision as displayed option or rounding the number normally. For more information on why this is a problem review this MS KB article:

http://support.microsoft.com/kb/214118/EN-US/

Thanks for the help. Very interesting article.

__________________
Neal

A Northern Soul