Re: I don´t view the value right after six decimal place in Excel
- From: Claudio <Claudio@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 6 Aug 2008 04:58:01 -0700
The procedure informed does not work. I wish that I send the Schedules so you
can make the tests?
If so, tell me your e-mail. Thank you.
"joeu2004" wrote:
PS.....
On Aug 5, 9:02 am, Claudio <Clau...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
From the sixth decimal place of any number in Excel does not present
the accuracy of the system in Cobol.
Would I like to do this in Excel? (have the same accuracy from the sixth
home)
This might help.....
For every calculation, use the ROUND() function to set the result to
the desired precision. You might want to do that around intermediate
results (subexpressions) as well as final results. This ensures that
the internal binary representation is exactly the same as if you had
entered the result as a constant.
That still might have the same effect as COBOL decimal arithmetic.
But it should reduce the effects of "propagation error". Consider
this example: enter =100*ROUND(2.00666666666667,2)-200 and compare
with 1. They are not identical in Excel 2003. Now compare 1 with
round(100*ROUND(2.00666666666667,2),0)-200.
You might consider setting the option Tools > Options > Calculation >
Precision As Displayed. But first, I believe that affects only the
final result, not intermediated calculations (subexpressions). And
second, it might not have the desired effect when using values with
different precisions.
If you experiment with this option, it would be wise to make a copy of
the workbook first because some changes cannot be undone by simply
unsetting the option and recalculating.
- References:
- Prev by Date: Selecting Data in a Table With percentage limits
- Next by Date: Font size in validation list
- Previous by thread: Re: I don´t view the value right after six decimal place in Excel
- Next by thread: I don´t view the value right after six decimal place in Excel
- Index(es):
Relevant Pages
|
