Thread: Formula error
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.newusers
Ken Wright Ken Wright is offline
external usenet poster
 
Posts: 634
Default Formula error

Do be aware that the cell does not actually EQUAL 0, it simply APPEARS to be
so. You need to use something along the lines of both mine and Joe's
answers such as the ROUND function if you actually need it to really be an
absolute 0.

Regards
Ken.........................


"Dee" wrote in message
...
Thanks much!!! I formated the cell to "numbers" and it gave the correct
answer. Kinda wierd that the other cells are "general" and work fine....


Anyway................you have taught me a new tool and fixed the
problem:)



"Ken Wright" wrote:

Probably nothing.

See here for the probable cause:

http://cpearson.com/excel/rounding.htm

Ignore the fact that the page says Excel 97, as you aill also see in the
small print it actually applies to all versions of Excel.

If you simply format to acctg or some numerical format and a few decimal
places of precision, it will appear as 0.

Regards
Ken...............................


"Dee" wrote in message
...
I have a simple calculation C8-C14 that I use to figure my budget
difference. It works in all the monthly columns I have set up except
for
one. I get a result of

-1.42109E-13

What could I have done wrong?????