Forum Discussion
SamN778
Sep 13, 2023Copper Contributor
IF formula not returning matching text - how to correct?
Hey everyone - hitting a very odd problem with the IF formula. I'm trying to reconcile a new data source with an old data source so that I can remove everything in the old data source. The two differ...
HansVogelaar
Sep 13, 2023MVP
SamN778
Sep 13, 2023Copper Contributor
That worked! Do you have an understanding why the IF statement does not work?
Thank you!
- HansVogelaarSep 13, 2023MVP
Your formula returned "True" and "False" as text values; those are not the same as the TRUE and FALSE returned by the formula that I proposed. Column B must contain TRUE and FALSE.