RE: What is this option for?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Sir Jerry,
Again, I think i need to turn some loose nuts on my understanding with excel.

Perhaps you have confused this edit option with the calculation option
"Precision as displayed" which rounds all values and results to the display
precision?


i just wonder if All values are really rounded as been displayed Along with
the calculation mode for Arrayed formulas handling different search/sum/count
criterias. The Tools>Formula auditing>Evaluate formula doesn't sometime
evaluate the values in the Order of the Checked Precision...

Are there any built-in or macros for tools or options that can surely unify
the Precision tool and Formula evaluation tool - expected result - for
mini-complex formulas that we learn from this forum-only.

I also wonder why upon checking the "Precision as Displayed" check box, a
Pop-Up message says "Data will permanently LOSE accuracy.! "
Yet in some respect, may i write that it is more accurate and hence "IF
Formula will gain accuracy.." Other than the arrayed "with criteria" formulas.

Please advise..

regards,
driller

--
*****
birds of the same feather flock together..



"Jerry W. Lewis" wrote:

"Fixed decimal" has to do with how you enter data, not how Excel calculates
formulas. For instance, if you check "Fixed decimal" and set "Places" to 2
and then enter 1035, Excel will accept the value as 10.35 (it will put the
decimal point 2 places in without you having to type the decimal point.

Perhaps you have confused this edit option with the calculation option
"Precision as displayed" which rounds all values and results to the display
precision?

Jerry

"driller" wrote:

Hello again,

Based on a reading from previous question dtd. 28.4.07. "EXCEL IF FUNCTION"

On an open workbook, I click
Tools>Option>EDIT>"fix decimals" [checked]
e.g. 2

Cell A1 : 10209.00
Cell A2:10208.70

A3=IF(A1-A2=0.3,3,0)
The expected result was not correct in due respect with the Option availed
by my excel 2003.

I wonder how will this option be indeed fairly adjust my needs with
Formulas. Maybe a macro or something simple from our contributing members can
help me with this..

Thanks for trying.

--
regards,
driller
*****
birds of the same feather flock together..
.

Relevant Pages

  • Re: why>?
    ... Using Change or Calculate events to check validation does slow Excel ... BeforeClose and BeforePrint events to check validation and display ... if i am only ever going to display it with 2 digits of precision; ... that's just how spreadsheets work. ...
    (microsoft.public.excel)
  • RE: Regression results
    ... What I am recording are weekly closes of stocks and the precision displayed ... polynomials, assuming that the x-values themselves are really accurate enough ... Your mention of "the formula provided by the graph" raises another issue: ... the equation and change the numeric format to display scientific notation ...
    (microsoft.public.excel.programming)
  • Re: Some values are off by a penny in the merged document
    ... Excel is where this can be controlled. ... Tools>Options>Calculation where there is a checkbox for 'Precision as ... > Some of the values in my merged document are off by a penny. ... > in the merged document might display in the merged document as $10,762.27, ...
    (microsoft.public.word.docmanagement)
  • Re: excel generated polynomial equation is wrong
    ... M> decimal places yet Excel will only display precision to 15 ... 15 digit precision Excel stores and calculates with 15 significant digits of precision. ...
    (microsoft.public.excel.misc)
  • Re: How Excel to do calculations using more than 12 digits precisi
    ... Why would Excel allow the display of 30 digits... ... Evidently even though Excel allows the selection of 30 digits display to ... can be downloaded and promise to allow greater precision calculations ...
    (microsoft.public.excel.worksheet.functions)