DJX

[Logical test returns incorrect answer]

I have a cell (I26) that contains the value "Water".
In another cell (J26) I have the formula =I26="Water"
The cell keeps returning a FALSE value when I can see with
my own eyes that (J26) should return TRUE. I was initially
trying to enter in an IF statement with the word as part
of the criteria but it seems that I did something wrong or
forgot something. Any help would be appreciated. Thanks

In J26 I was trying
=IF(I26="Water",B34,B35)
I keep getting the value for B35 even though Water is
clearly the value in I26.

 

[Peo Sjoblom]

Try


=IF(ISNUMBER(FIND("Water",I26)),B34,B35)

if that works you have hidden characters, there might be only spaces
or the more sinister char(160) (invisible html crap)
--

Regards,

Peo Sjoblom


"Logical test returns incorrect answer"

 

[Trevor Shuttleworth]

select the cell, I26, and press F2. If the word starts at the very left of
the cell and the cursor is next to the last character, you have "water" in
the cell. If not, you have some other non printing or displaying character
.... quite possibly a space. What you see is not all that is there !

Regards

Trevor

"Logical test returns incorrect answer"