It turns out the "precision as displayed" box was ticked. This has corrected
the problem. Thanks for the useful tips.

"Jerry W. Lewis" wrote:

I am not aware of any instances where Excel's basic arithmetic does not
work correctly. Please post your equation.

Jerry

Robin wrote:

I am experiencing a bizarre phenomenon in Excel. I received a file from a
customer and there is an instance where, multiplying two cells together, the
answer is incorrect by about 0.02%. I am dealing with large numbers so I
cannot ignore this. I am not a beginner with Excel and have checked all
possibilities such as ensuring cell format is number and not text, etc. Its
almost like its rounding the values off in the background, but its not. Has
anyone got any ideas?