Is this a bug ? decimal bug ?

[nengie]

Try this

? ROUND(1219.000000*3.795,2) = 4626.11
? ROUND(1219.000000*3.7950,2) = 4626.10
? ROUND(1219.000000*ROUND(3.7950,4),2) = 4626.10
? ROUND(ROUND(1219.000000,4)*ROUND(3.7950,4),2) = 4626.11

The result should be 4626.105 and round(4626.105,2) = 4626.11.

Any idea ? TIA

 

[tesar]

No bug.
If you wrote 3.7950 exactly, is it different from 3.795,
as may be 3.7951, 3.7952, ... 3.794999...
Potential digit right raise result.
Tesar

 

[Mike Gagnon]

That problem has been around a long time. Refer to this article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q157954