SOLVED

Formulas won't contvert to value in cell

%3CLINGO-SUB%20id%3D%22lingo-sub-2340536%22%20slang%3D%22en-US%22%3EFormulas%20won't%20contvert%20to%20value%20in%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2340536%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20entering%20av%20formula%20in%20a%20cell%2C%20it%20does%20not%20perfom%20the%20action%2Fconvert%20to%20value%2C%20it%20just%20presents%20the%20formula%20in%20text%20format.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3CU%3EHere%20are%20some%20examples%3C%2FU%3E%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22254%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2296px%22%20height%3D%2228px%22%3E1%3C%2FTD%3E%3CTD%20width%3D%2272px%22%20height%3D%2228px%22%3E1%3C%2FTD%3E%3CTD%20width%3D%2284px%22%20height%3D%2228px%22%3E%3CSTRONG%3E%3DA82%2BA82%3C%2FSTRONG%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3EHere%20the%20third%20cell%20should%20convert%20to%20%222%22%2C.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22372%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22370.667px%22%20height%3D%2228px%22%3EUntrue%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22370.667px%22%20height%3D%2228px%22%3ETrue%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22370.667px%22%20height%3D%2228px%22%3ETrue%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22370.667px%22%20height%3D%2228px%22%3EUntrue%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22370.667px%22%20height%3D%2228px%22%3E%3CSTRONG%3E%3Dcount.if(A4%3AA79%3B%22True%22)%3C%2FSTRONG%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3EHere%20the%20latest%20cell%20should%20convert%20to%20%222%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20clues%20to%20how%20I%20can%20fix%20this%3F%3C%2FP%3E%3CP%3EThe%20document%20is%20created%20through%20Teams%2C%20don't%20know%20if%20that%20matters%3F%20But%20the%20problem%20sustains%20when%20trying%20to%20open%20the%20document%20in%20Eether%20the%20Sharepoint%20version%20or%20the%20Desktop%20version.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2340536%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2340557%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%20won't%20contvert%20to%20value%20in%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2340557%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1049709%22%20target%3D%22_blank%22%3E%40Marianne90%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20uncheck%20Show%20Formulas%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20757px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F279428iB880F2703F107B40%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2340738%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%20won't%20contvert%20to%20value%20in%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2340738%22%20slang%3D%22en-US%22%3EThank%20you...%20how%20easy%20that%20was!%3CBR%20%2F%3EMuch%20appreciated.%20%3Agrinning_face%3A%3C%2FLINGO-BODY%3E
New Contributor

When entering av formula in a cell, it does not perfom the action/convert to value, it just presents the formula in text format. 

 

Here are some examples:

 

11=A82+A82

Here the third cell should convert to "2",.

 

Untrue
True
True
Untrue
=count.if(A4:A79;"True")

Here the latest cell should convert to "2".

 

Any clues to how I can fix this?

The document is created through Teams, don't know if that matters? But the problem sustains when trying to open the document in Eether the Sharepoint version or the Desktop version.

3 Replies
best response confirmed by Marianne90 (New Contributor)
Solution

@Marianne90 

Please uncheck Show Formulas

image.png

Thank you... how easy that was!
Much appreciated.

@Marianne90 , you are welcome