Home

Formula appearing in cell instead of the result

%3CLINGO-SUB%20id%3D%22lingo-sub-663653%22%20slang%3D%22en-US%22%3EFormula%20appearing%20in%20cell%20instead%20of%20the%20result%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-663653%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spreadsheet%20with%20many%20tabs%20and%20look%20ups%20between%20the%20tabs%2C%20some%20cells%20have%20the%20formula%20showing%20instead%20of%20the%20result%20for%20the%20look%20up%3F%3C%2FP%3E%3CP%3ECan%20anyone%20help%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGeoff%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-663653%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-663675%22%20slang%3D%22en-US%22%3ERE%3A%20Formula%20appearing%20in%20cell%20instead%20of%20the%20result%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-663675%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Geoff%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20Ctrl%20%2B%20%60%20in%20the%20sheet%2Fs%20that%20have%20the%20issue.%20You%20may%20be%20looking%20at%20the%20formula%20instead%20of%20the%20result%20on%20those%20sheet%2Fs.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%20Damien%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EP.S.%20Also%20check%20to%20see%20that%20nothing%20is%20in%20front%20of%20the%20%3D%20in%20that%20cell%20as%20well.%20If%20something%20like%20'%3DIF(...%20then%20you'll%20see%20the%20formula%20text.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Geoff2017
Occasional Visitor

I have a spreadsheet with many tabs and look ups between the tabs, some cells have the formula showing instead of the result for the look up?

Can anyone help

 

Geoff

1 Reply

Hi Geoff

 

Try Ctrl + ` in the sheet/s that have the issue. You may be looking at the formula instead of the result on those sheet/s.

 

Cheers Damien

 

P.S. Also check to see that nothing is in front of the = in that cell as well. If something like '=IF(... then you'll see the formula text.

Related Conversations