Thread: Formula error
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
DEE DEE is offline
external usenet poster
 
Posts: 250
Default Formula error

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?????