Quote:
Originally Posted by riothecat
I have a spreadsheet, again, that has an amount error after the calculations.
|
Very likely, this is due to a common issue with binary computer arithmetic, due to the fact that most decimal fractions cannot be represented exactly.
For example, IF(10.01 - 10 = 0.01, TRUE) returns FALSE(!) because 10.01 - 10 is 0.00999999999999979.
In general, if you expect arithmetic to be accurate to n decimal places, you should explicitly round the expression to
that number of decimal places.
(Not to an
arbitrary number of decimal places like 10, as some people suggest.)
For example, IF(
ROUND(10.01 - 10
, 2) = 0.01, TRUE) returns TRUE, as expected.
Quote:
Originally Posted by riothecat
I tried to attach it but I hit browse my computer highlight the file add attachment and nothing. Tell me how to attach and I will.
|
See the paperclip icon in the toolbar for the Message pane. If that does not work, upload the Excel file to a file-sharing website, and post the public/share URL in a message here.