Forum Discussion
Solved
IF formula returns FALSE if source cell is the result of another formula.
I have an IF THEN formula that returns false when the reference cell is the result of a formula, But returns true if I type the result in as if there was no formula
I guess it was because the reference was to a table cell. If you make a reference to another cell, the result was fine. I couldn't figure out what was responsible though.
To resolve this temporarily, if you still want to keep the reference to the table cell, just multiply C2 content by 1, you will be good.
=RankingResults[@[E.Mindset Overall Score]]*1Cheers
