Many computer programs don't use equality to zero to test subtractive
results. Instead, if the difference is less than some really small
number, you substitute 0 for the actual result. E.g, instead of

=A1-B1
use
=IF(ABS(A1-B1)<0.00000001,0,A1-B1)

Thus, if the difference between A1 and B1 is less than 0.00000001, the
numbers are assume to be "close enough" to equal that they can be
treated as such. This isn't a bug in Excel. It is simply the result
of how nearly every piece of software in the world works with very
small numbers.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)





On Tue, 20 Jan 2009 11:43:02 -0800, frecar
wrote:

I netted debits and credits and the answer is zero - it appears - as it
should be. However, there are decimal values beginning about decimal place
twelve. This keeps me from uploading an electronic journal entry because our
software Peachtree says the entry is out of balance.