Re: Errors in formula calculation

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Ron Rosenfeld (ronrosenfeld_at_nospam.org)
Date: 02/08/05 

Date: Tue, 08 Feb 2005 14:37:08 -0500

On Tue, 08 Feb 2005 13:58:07 GMT, "john.bedford3" <john.bedford3@ntlworld.com>
wrote:

>Is this simply because it is converting to binary and back to decimal?
>
>If I attempt to use precision as displayed a warning comes up that data will
>permanently lose accuracy. Yet it is inaccuracy of the calculation I am
>trying to get rid of.
>
>I have now tried using ROUND and this appears to solve the problem although
>I did not think of that before as simple addition does not indicate that
>there should be more than one decimal place in the answer.
>
>Hopefully this has solved my problem.
>
>Thank you for your help

I'm glad you have solved your problem. And Lewis has given a much clearer
explanation of the issues.

--ron

Relevant Pages