This is a simplified case of an issue that I am seeing using MS Excel 2007.
Format your sheet to be currency with 2 decimal places.
Cell A1 type 25
Cell A2 type 20.13
Cell A3 type 4.87
CELL B3 enter the formula =A1-A2
Cell A4 enter the formula =IF(A1-A2=A3,"TRUE","FALSE")
Cell B4 enter the formula =IF(A3=B3,"TRUE","FALSE")
ERROR is A4 displays FALSE and B4 displays FALSE
NOTE: I first noticed a precision error with the simplified version. So first I changed the precision to calculate by display using this guide. That fixed my simple version, but I still saw the issue on my page. I changed the display of decimals to be 12 decimal places, everything after the second decimal place is a zero on all values on the sheet.
Does anyone have any suggestions on what else I can try to fix my formula/worksheet.
ROUND(
one)? Theas displayed
method only works in result-cells. You can't use these cells to do further calculations because the they are only displayed correctly (but internal they are still "off") Always useround(
in these circumstances.round(
.