In cell H:212, a formula is calculating a very tiny decimal error.
I have several columns. Column C is entered manually, Column D is the formula =C3+A4-B4, and Column E is the formula =C4-D4.
15.01 -
1,168.29
1,168.29 -
-
43.00 1,125.29
1,125.29 -
-
1,125.00 0.29
0.29
0.00
950.00 -
950.29
950.29
-
I noticed the 0.00. When I increased the decimals to 30 places, it's calculating 0.29-0.29 as 0.000000000000036359804056473900.
Haven't the slightest idea why, although I suspect that there may be something wrong in the underlying code that corresponds to cell H:212; since I've repeatedly copied those formulas through the spreadsheet, thousands of rows deep. The teensy decimal doesn't
appear anywhere else but cell H:212. I've deleted the formula and started over. I've also copied the formula in other locations, where it works properly, and once I hit cell H:212, I get the same error.