Rounding Inconsistency...

[Jossy]

Hi,

I've recently encountered an issue when summing a range of data. I've attached a file to try and illustrate the issue - basically I'm at a loss to understand why the purple cell doesn't equal the green cell. Are there any limitations on rounding I'm not aware of?

Can anyone shed any light on this?

Thanks in advance,

Jossy

[DonkeyOte]

see: http://support.microsoft.com/kb/78113