AppleWorks: Problems with calculations in spreadsheets

If, in cell A1, you enter the formula 17.9-17*10, the cell will display 9, the correct result. If you then enter, in cell A2, @INT(A1), the cell will display 8. Even if you try the @IF, the result will always be something less than 9.
This phenomenon is not the application's fault: it's that old standard floating point error. Remember that 17.9-17 isn't .9, but rather .899999, so that when you multiply by 10, you get 8.99999--and @INT(8.9999) = 8. The best workaround is to use @INT(A1+0.5) instead.
Published Date: Feb 18, 2012