....relies heavily on toolsOptionsCalculation"Precision as displayed"

thanks so much..Sir Jerry

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



"driller" wrote:

Now i have known here the difference for Precision and Fix decimals options.
So I may try not to forget the If function precision.


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
ToolsOptionEDIT"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..