Forum Discussion
If Function
I am having problem with a very simple "IF" function. I am comparing two columns of data from different sources. It's basically IF( a2 = b2, true, false) Even if the values are exactly the same, it ...
Hi
If A2=B2 equals FALSE then both values are definitely not identical.
If it is text check for extra spaces.
For numbers check ISNUMBER(A2) and ISNUMBER(B2). Both should be TRUE.
And increase the number of decimal places.