L
Lee
I have experienced a bug with excel. It doesn't happen
all the time, but it has happened on more than one
occasion.
The problem is when I add cells together, the formula
doesn't come out to the right answer. The following is an
example (shown with 4 decimal places):
Add: 22,112.5200
161,241.7800
15,000.0000
Less: (40,222.0100)
(157,000.0000)
________________________
1,132.2900 - should be the correct
answer, but instead the answer reads:
1,132.289999999995
all the time, but it has happened on more than one
occasion.
The problem is when I add cells together, the formula
doesn't come out to the right answer. The following is an
example (shown with 4 decimal places):
Add: 22,112.5200
161,241.7800
15,000.0000
Less: (40,222.0100)
(157,000.0000)
________________________
1,132.2900 - should be the correct
answer, but instead the answer reads:
1,132.289999999995