In article ,
Michele wrote:

i have triple checked my numbers and can't find any that are not what they
shold be. Is there a way to find out which one is causing the prob.

There isn't a particular number that's causing your problem. It's a
problem with the fact that decimal numbers can't always be represented
by a fixed number of binary digits, which is what the math processor
deals with. So when the math processor has to work with these numbers
with slight errors in representation, the result often has a slight
error in representation.

This isn't a problem if you just want to display the number - the
display engine will round it for you.

But XL has no way of knowing, when you compare the value to zero,
whether that slight error is significant to you or not. With currency,
a value of that magnitude certainly is insignificant. With engineering
calculations - perhaps or perhaps not.


There is no way to prevent this other than using integers - It's
inherent in all computers and all spreadsheets. So one deals with it by
using ROUND(xxx,2) for currency.