When comparing the number from our business application written in Visual FoxPro, we have come accros a problem that we find disturbing.
In the following, Excel is adding the true value of the numbers before it rounds to 2 decimals.
Excel Foxpro
520.0000 520.00
238.6350 238.64
127.3756 127.38
456.2375 456.24
-------- -------
1342.2481 1342.26
The cells in Excel are formatted to "Currency" which shows 2 decimals by default. The value of the cells is a sum of a calculation. example: =A1*B1 etc...
The Foxpro figures are added using the totals after rounding.
Which are the currect figures to use? Or how do you make Excel round to the 2 decimal before it adds the figures.
Please let me know if this an Excel bug or are we attempting to be to close with the numbers.
Thank You
stripe@cybertron.com