|
|
#1
08-28-2007, 08:20 AM
|
|||
|
|||
Excel formula shows shows -2.2E-13 instead of 0 in one case only. help
I use excel to track my winnings at the sites I play at. I have a pretty simple sheet with the following columns in the picture below, date, start total, end total, proit, other. I use other for deposit, withdrawal, bonus, etc.
 I use a formula for the profit column, C-B-E. Now for some reason today it gave me this number instead of 0. It works on any other day that it should total out to zero, as I show below. If I change the E column to any other value then the profit column shows what it you would expect it to show. Any ideas why I would be getting this number for just this one particular example? 
|
|
#2
08-28-2007, 09:50 AM
|
|||
|
|||
|
Re: Excel formula shows shows -2.2E-13 instead of 0 in one case only. help
Make sure the cells are formatted correctly and didn't somehow change formats.
Meaning, make sure the cell is a "number" format with two decimal places or a currency format with two decimal places.
|
|
#3
08-28-2007, 10:01 AM
|
|||
|
|||
|
Re: Excel formula shows shows -2.2E-13 instead of 0 in one case only.
You might also want to look to see if the other numbers are rounded to 2 decimal places or not. For example, is it 44.99 or something like 44.991736?
|
 |
|
|
Linear Mode
