You must have posted this before my last post went up. I realized the article
you sent me was very helpful. Thank you very much

"T. Valko" wrote:

Unfortunately there are no formulas in the excel that I am referencing.

What do you think this is:

=-187992-213510-828672.8-1025000+828672.8+213510+1025000+187992

It *is* a formula.

See what Microsoft has to say about it:

(Complete) Tutorial to Understand IEEE Floating-Point Errors
http://support.microsoft.com/kb/42980

How to correct rounding errors in floating-point arithmetic
http://support.microsoft.com/kb/214118


--
Biff
Microsoft Excel MVP


"EggMan903" wrote in message
...
Thank you for your response.

Unfortunately there are no formulas in the excel that I am referencing. I
just typed in those 8 numbers, added them up, and got that answer. You
could
also type in
=-187992-213510-828672.8-1025000+828672.8+213510+1025000+187992 and you
will
get the answer of 2.32831E-10. It is currently formated to general and I
know I can format it to number and it would show as 0 but why does it show
as
that value to begin with.


"T. Valko" wrote:

See this:

http://www.cpearson.com/Excel/rounding.htm

Although the atricle mentions Excel 97 it's applicable to all versions of
Excel.

--
Biff
Microsoft Excel MVP


"EggMan903" wrote in message
...
Can anyone tell me why when you enter this into a cell

=-187992-213510-828672.8-1025000+828672.8+213510+1025000+187992

The value comes out 2.32831E-10 when it should clearly be 0. I know I
can
format the cell to show as 0 but why does it ever show as 2.32831E-10
when
it
is impossible to have those numbers equal anything other then 0.


Thank you