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.

http://i65.photobucket.com/albums/h2...ules/excel.jpg

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?

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.

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?