>It is rounding correctly. 1.3749 is less than 1.3750, so it is rounded down.
OK, I'll accept that. Now, consider this equation:
15000000*.01721250*82/360
This produces a result of 58809.375.
However,
ROUND(15000000,3)*.01721250*82/360
will produce 58809.37499999999
Now, as far as I can see 15,000,000 is the exact same value in both equations because everything to the right of the decimal is zero. What is the explanation for the difference in results? This phenomenon does not happen on my calculator, nor does it happen in Excel. The reason I'm harping on this is because this is showing up in our interest calc/accounting application. Mutiply that problem by a whole lot of trades and you have a big accounting problem. :)
Jon
Jon Rosenbaum
Devcon Drummer