Prev: Icon Sets - Display icon in one cell depending upon value in a
Next: SUMPRODUCT to substiute array formula
From: JLatham on 26 Feb 2010 09:55
The problem could also because by internal rounding error. There may be a
tiny fraction of a decimal not being seen, and so 0<>0, or so it may appear.

Here's an example:
In A1 type the formula
=64.4 - 64
in B1 simply type in .4
in C1 put the formula =IF(A1=B1,"Equal","Not Equal")
The result will be "Not Equal" because the calculation 64.4-64 actually
returned
0.400000000000006 !

If this seems to be the problem, you can try ROUND() or even change the
Excel Options to "Precision as Displayed", just be cautious with that last
one.



"Lake Oswego" wrote:

> Excellent work! I did convert that column to text because I was getting
> desperate about my Match not working and was trying everything. I have found
> several people who have experienced two cells that look and smell the same
> but Match won't treat them as the same. We have to be talking about some
> hidden formatting that causes Exact to see a difference when we don't.
>
> "T. Valko" wrote:
>
> > It sounds like the cells are formatted as TEXT.
> >
> > Change the format to GENERAL.
> >
> > Then, select the cell and either double click or hit function key F2 then
> > hit Enter.
> >
> > If you have a bunch of cells to convert...
> >
> > Select all the cells in question
> > Change the cell format to GENERAL
> > With the cells still selected
> > Goto the menu Edit>Replace
> > Find what: = (equal sign)
> > Replace with: = (equal sign)
> > Replace All
> >
> > --
> > Biff
> > Microsoft Excel MVP
> >
> >
> > "Lake Oswego" <LakeOswego(a)discussions.microsoft.com> wrote in message
> > news:C6E17FAB-C50B-4D10-8CD8-565F16713F51(a)microsoft.com...
> > > Formulas which used to calculate, then disappear leaving only the answer,
> > > now
> > > remain without showing the answer. If I replace = with =, it works but
> > > only
> > > in that case. How can I get back to normal?
> >
> >
> > .
> >
First  |  Prev  | 
Pages: 1 2
Prev: Icon Sets - Display icon in one cell depending upon value in a
Next: SUMPRODUCT to substiute array formula