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
- SamN778Sep 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.