Here is the formula I copied from a table that worked.

=IF(D48="","",IF($B$24=25,"",IF(D3=D48,"YES","") ))

The same formula in my new table doesn't work.


On Thu, 20 Dec 2007 02:37:06 -0800 (PST), joeu2004
wrote:

If you are still looking for assistance, I suggest that you cut-and-
paste the formula from the Excel into your posting.

I suspect that instead of "B6=25", it now reads "26=25 or "86=25"
or some other typo that can easily be misread as "B6=25" because that
is what you expect.

At least, that is one kind of "stoopid" mistake I discover I have made
when things no longer work inexplicably. We tend to read what we
expect, not always what is there before us.


----- original posting -----

On Dec 20, 2:22 am, RF wrote:
Thank you. The first formula I posted worked fine. I was having some
other problems, fixed those, and then that very same formula would no
longer work.. So, out of frustration I reversed the B26=25 to
B26<=25 to see what would happen, and it worked. I had no idea what
was going on.

The value in B26 is 8.
The value in G5 is 58.
The value in G50 is 25.

If G5 is greater than G50 I want the cell in G26 to say "YES."

But if B6 is = 25, and even though G5 is greater than G50, I want the
cell to be blank.

This is how the formula should look and it should work, but it doens't
work now unless I reverse the B26=25 to B26<=25, and I cannot fathom
why.

=IF(B26=25,"",IF(G5=G50,"YES",""))

The above formula is the one I'm working with. Forget about the
B26<=25 stuff. This is what I'm trying to solve. It was working, it
should work, but after hours of playing with it I give up.

Thanks for your help.