AppleWorks
J
__________________________________________________________________
Dollars & Cents Round Incorrectly
__________________________________________________________________
Problem:  Dollars and cents do not round correctly when 
multiplying, dividing, adding or subtracting in versions of 
AppleWorks prior to 3.0.

Solution:  Formatting dollar amounts to two decimal places with 
Open Apple-L will not automatically round calculations to two 
decimal places.  Use the @Round function to ensure proper 
rounding.  Due to the nature of binary arithmetic and SANE, it may 
be necessary to add a small correction to the calculation before 
applying the round function.  If calculations are not quite 
rounding correctly, especially those whose last significant digit 
is a "5 " (e.g., 33.345),  the following correction should be used 
to compensate for floating point arithmetic:  

@Round(Calculation+.0000001,2).