Jim,
Looks like the discrepancy exists for the particular Reference number only. Somehow the original data in the table don't match my calculatations. In all other 51 cases they match exactly.
>Naomi,
>
>Here's an example to show you what is happening.
>
>
>
>with 2 decimals
>
> 9.99
> 10.23
> 10.55
>sum 30.77
>
>with currency
>
> 9.9999
> 10.2390
> 10.5590
>sum 30.7970
>
>shift to 2 decimals 30.80
>
>
>Now extend that to a larger number of values and you can see where the $5 discrepancy comes from.
If it's not broken, fix it until it is.
My Blog