SOLVED

IF formula returns FALSE if source cell is the result of another formula.

%3CLINGO-SUB%20id%3D%22lingo-sub-1605366%22%20slang%3D%22en-US%22%3EIF%20formula%20returns%20FALSE%20if%20source%20cell%20is%20the%20result%20of%20another%20formula.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1605366%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20have%20an%20IF%20THEN%20formula%20that%20returns%20false%20when%20the%20reference%20cell%20is%20the%20result%20of%20a%20formula%2C%20But%20returns%20true%20if%20I%20type%20the%20result%20in%20as%20if%20there%20was%20no%20formula%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1605436%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20formula%20returns%20FALSE%20if%20source%20cell%20is%20the%20result%20of%20another%20formula.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1605436%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767668%22%20target%3D%22_blank%22%3E%40Hewtee%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20might%20be%20some%20information%20in%20the%20file%20that%20is%20not%20captured%20on%20the%20png%20file%2C%20which%20may%20assist%20to%20detect%20the%20issue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20you%20able%20to%20share%20the%20file%20after%20removing%20confidential%20information%20so%20we%20can%20go%20through%20together%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1605536%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20formula%20returns%20FALSE%20if%20source%20cell%20is%20the%20result%20of%20another%20formula.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1605536%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F622486%22%20target%3D%22_blank%22%3E%40wumolad%3C%2FA%3E%26nbsp%3B%20Yes%20please%20I%20would%20appreciate%20theat%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1605706%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20formula%20returns%20FALSE%20if%20source%20cell%20is%20the%20result%20of%20another%20formula.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1605706%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767668%22%20target%3D%22_blank%22%3E%40Hewtee%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOk.%20Please%20share%20the%20file%20when%20you%20are%20ready.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1605732%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20formula%20returns%20FALSE%20if%20source%20cell%20is%20the%20result%20of%20another%20formula.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1605732%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F622486%22%20target%3D%22_blank%22%3E%40wumolad%3C%2FA%3E%26nbsp%3BThank%20you%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERaw%20data.xls%20is%20the%20source%20of%20data%20for%3C%2FP%3E%3CP%3EAnalysys%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1605895%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20formula%20returns%20FALSE%20if%20source%20cell%20is%20the%20result%20of%20another%20formula.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1605895%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767668%22%20target%3D%22_blank%22%3E%40Hewtee%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20guess%20it%20was%20because%20the%20reference%20was%20to%20a%20table%20cell.%20If%20you%20make%20a%20reference%20to%20another%20cell%2C%20the%20result%20was%20fine.%20I%20couldn't%20figure%20out%20what%20was%20responsible%20though.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20resolve%20this%20temporarily%2C%20if%20you%20still%20want%20to%20keep%20the%20reference%20to%20the%20table%20cell%2C%20just%20multiply%20C2%20content%20by%201%2C%20you%20will%20be%20good.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DRankingResults%5B%40%5BE.Mindset%20Overall%20Score%5D%5D*1%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1606204%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20formula%20returns%20FALSE%20if%20source%20cell%20is%20the%20result%20of%20another%20formula.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1606204%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F622486%22%20target%3D%22_blank%22%3E%40wumolad%3C%2FA%3E%26nbsp%3B%20Thank%20you%20soo%20much.%20Bless%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1606719%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20formula%20returns%20FALSE%20if%20source%20cell%20is%20the%20result%20of%20another%20formula.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1606719%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767668%22%20target%3D%22_blank%22%3E%40Hewtee%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGreat%20to%20be%20of%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20enjoy%20the%20weekend.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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

7 Replies

Hi @Hewtee 

 

There might be some information in the file that is not captured on the png file, which may assist to detect the issue.

 

Are you able to share the file after removing confidential information so we can go through together?

 

Cheers.

@wumolad  Yes please I would appreciate theat

@Hewtee 

 

Ok. Please share the file when you are ready.

@wumolad Thank you

 

Raw data.xls is the source of data for

Analysys

Best Response confirmed by Hewtee (Occasional Contributor)
Solution

@Hewtee 

 

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]]*1

 

Cheers

 

@Hewtee 

 

Great to be of help.

 

Do enjoy the weekend.

 

Cheers