Re: Errors in formula calculation
From: Ron Rosenfeld (ronrosenfeld_at_nospam.org)
Date: 02/08/05
- Next message: davegb: "special edit fill-down"
- Previous message: Ray K.: "Close "X" missing"
- In reply to: john.bedford3: "Re: Errors in formula calculation"
- Next in thread: Jerry W. Lewis: "Re: Errors in formula calculation"
- Messages sorted by: [ date ] [ thread ]
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
- Next message: davegb: "special edit fill-down"
- Previous message: Ray K.: "Close "X" missing"
- In reply to: john.bedford3: "Re: Errors in formula calculation"
- Next in thread: Jerry W. Lewis: "Re: Errors in formula calculation"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
