"atin" wrote:
"Teethless mama" wrote:
=IF(ROUND(L7,2)=0.1,L7,"")

Again, referring to your link to
http://spreadsheets.google.com/ccc?k...DZqnlQHllepUYQ in another
posting in this thread....

Alternatively and arguably more reliably, in K54 you could write:

=ROUND(SUM(D54:J54),2)

and in L54 you could write:

=ROUND(B54+C54-K54,2)

and similarly use ROUND in every formula that involves arithmetic with
numbers that might have decimal fractions. Then in N54, you can write
simply =IF(L54=0.1,L54,"") and get the expected results.

The prolific use of ROUND in computational formulas, not just in
comparisons, is more reliable because it minimizes the propagation of the
infinitesimal numerical abberations that I explained in several other
postings in this thread, which are an avoidable consequence of the way that
Excel (and most applications) represent numbers and perform arithmetic
internally.

The use of ROUND ensures that the underlying value exactly matches the
displayed value if you had typed the displayed value as a constant.
Formatting alone does not change the underlying value. For example, L54 is
actually about 0.0999999999999996, but it is displayed as 0.1.


----- original message -----

"atin" wrote in message
...
Thanks for formula, it works. But can you explain the logic of formula. I
am
not able to understand it exactly.

"Teethless mama" wrote:

=IF(ROUND(L7,2)=0.1,L7,"")


"atin" wrote:

Problem- Problem- Excel not recognising or counting values between
'0.01 to
0.99' in
cells containing formula. Exact sheet can be downloaded at-
http://www.aensia.com/test.zip

In the sheet you download - I want to know which stock is equal to 0.1,
0.2,
0.3 and so on.

Excel is not giving right values in (stock equal to 0.1, 0.2 and
others).

Is there any solution to this.