Using Double variable to store numbers from math formulas, I'm not able to get the correct rounding from national currency to EURO. That is, when the result is, for instance, 37.42500 I should have my variable (formatted with ##0.00) equals to 37.43 . Instead, I get 37.42 that is wrong up to conversion rules defined by international laws.
If the number is 37.43500 I get the correct 37.44 as expected.
Using the same variable defined as Currency I get the correct result.
Does this mean that I cannot rely on variables defined Double to get the correct result (or even to get always the same rounding !)?
Thanks in advance