otherstuff
New Member
- Joined
- Apr 17, 2014
- Messages
- 5
Below is the data in question, I have expanded the decimals to show it's not the result of our inputs. The third column is a formula that adds the second and subtracts the first from the preceding balance (a rolling bank balance). The row in Bold shows where Excel suddenly creates a value that has more than two decimal places. Why does this happen when all of the inputs are no longer than two decimals? Why does $3,102,035.90 - $2,879,595.16 = $222,440.739999999, and not $222,440.74? As you can see from the preceding numbers there are no other decimals beyond the second digit until the formula.
I would like a solution that does not involve rounding every formula or having to use another function. This happens in many spots throughout our workbook but we aren't able to identify an issue with our inputs. Is there a fix? THANKS!
<tbody>
</tbody>
I would like a solution that does not involve rounding every formula or having to use another function. This happens in many spots throughout our workbook but we aren't able to identify an issue with our inputs. Is there a fix? THANKS!
- | 186,597.04000000000000000000 | 3,041,589.47000000000000000000 |
10,200.00000000000000000000 | - | 3,031,389.47000000000000000000 |
220,037.00000000000000000000 | - | 2,811,352.47000000000000000000 |
12,500.00000000000000000000 | - | 2,798,852.47000000000000000000 |
- | 312,983.43000000000000000000 | 3,111,835.90000000000000000000 |
9,800.00000000000000000000 | - | 3,102,035.90000000000000000000 |
2,879,595.16000000000000000000 | - | 222,440.73999999900000000000 |
6,250.00000000000000000000 | - | 216,190.73999999900000000000 |
- | 0.29000000000000000000 | 216,191.02999999900000000000 |
- | 285.46000000000000000000 | 216,476.48999999900000000000 |
- | 140,178.35000000000000000000 | 356,654.83999999900000000000 |
<tbody>
</tbody>