>Experiencing very specific problems when multiplying several variables (each having about 3 to 4 decimals), we could try out the following example:
>
>SET DECIMALS TO 2
>? 1/100 && result: 0.01
>? 1/1000 && result: 0.00
>? (1/1000)*1000 && result: 1.00
>? (1/1000000)*1000000 && result: 1.00
>
>but:
>
>SET DECIMALS TO 15
>? 1/100000 && gives: 0.000010000000000 = ok
>? 1/1000000 && gives: 0.000001000000000 = ok
>? 1/10000000 && gives: 0.000000000000000 = WHAT THE H'LL ??
>? (1/10000000)*10000000 && gives: 0.000000000000000 = ????
>
>So there must be definitely a calculation problem in Foxpro.
>
>If you read the manuals, you see: ... "
>The correct calculation is performed and stored internally, but all subsequent displays of the result use the DECIMALS setting at the time the number was calculated. ... "
>
>As calculators of HP or Texas Instruments or any other brand usually work with at least 10 or 14 figures behind the coma, I can't understand what Foxpro is doing here...
>
>Btw, using the ROUND function does allways return a correct result.

Does it? In my case even Round() did not return a valid value. It's puzzling.