The miniscule error may be even farther "down" than the 5th decimal place.
Try this, it may cure your problem:

Make a copy of your workbook and use it for this test. In the Tools --
Options dialog, go to the [Calculation] tab and select the "Precision as
Displayed" option. You'll be warned of a loss of precision when you apply
the change. This is a 'by workbook' change, so it won't affect other
workbooks. See if that clears up your problem.

"BabyMc" wrote:

I have tables of figures which I am extracting, via VLOOKUP, to different
reports. I am then compiling a total, of each of these values, in the reports
themselves.
Then I am comparing the total given in my report with the total that is also
included within the initial table and asking Excel to give me an error
message should the two amounts not balance.

I have done this many times without any issues - however I seem to have a
problem in some reports whereby I am receiving an error message even when the
value in the report matches the value in the table.

I have manually checked that the report adds up correctly - and the value in
the table. I have checked that neither value includes a spurious amount
within the decimal (down to 5 places).
I have also split my formula (that produces and error message) in to its two
halves - and these both return the same result.

I am afraid I can't fathom why I am getting an error message. Can anyone help?

Thanks