If function does not work

[jewellove]

Hello,

What is the best formula if D4 and L4 is text and the criteria is if text in D4 is same in L4 the result should be "OK"; Otherwise "False". I used =(IF(D4=L4;"OK";false)). It did not work.. Thank you in advance.

[:) Sixthsense :)]

Try this..

Please Login or Register  to view this content.

Hope this helps!

[jewellove]

Thank you sixthsense.. Your formula works..

[Teethless mama]

Short/Elegant version:


=AND(T(D4)=L4,T(D4)<>"")