Forum Discussion
Trying to use equation In excel but keep receiving false message
[ Spoiler ] Hi all, I am trying to submit =AI29=AJ29 into excel and it gave me a false message. I then tried to submit =IF(AI29=AJ29,TRUE,"") and it completely deletes the message. Im not sure w...
What do you mean by "it completely deletes the message"? The formula you mention would return a blank when it evaluates to a FALSE.
If the formula =AI29=AJ29 returns FALSE, it simply means that the two cell do NOT contain the exact same value. Are the both numbers, texts? Perhaps there are leading or trailing spaces in one or both but not in the same place.
I have faced the same issue, so what to do for this. I have checked the length for the numbers while it is not same