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

What result did you get, and what did you expect?

If you got 0 (like I did), but were expecting 3, you need to round your values.
Computers work in binary, and often don't translate decimal numbers properly.
The following should do what you want:

=if(round(a1-a2,2)=0.3,3,0)

--
Regards,
Fred


"driller" wrote in message
...
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..

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

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

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

....yet the conditional formatting formula may have another option <i dont
know where for its precision using the If function even with or without the
Precision As Displayed. Hoping there is a fix way..?

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



"driller" wrote:

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

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 ToolsFormula auditingEvaluate 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
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..