Excel Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2684844%22%20slang%3D%22en-US%22%3EExcel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2684844%22%20slang%3D%22en-US%22%3E%3CP%3EUsing%20a%20Mac%20Safari%2014.1.2%20and%20Excel.%20Trying%20to%20input%20a%20formula%3C%2FP%3E%3CP%3E%3DSUM(D5%3AF5)%20and%20enter%20and%20all%20I%20see%20is%20the%20formula%2C%20not%20the%20actual%20sum.%20WTF%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2684844%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2684974%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2684974%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1137575%22%20target%3D%22_blank%22%3E%40Dr_Eddie_B120%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E1)%20Make%20sure%20that%20the%20cell%20with%20the%20formula%20is%20%3CSTRONG%3Enot%3C%2FSTRONG%3E%20formatted%20as%20%3CSTRONG%3EText%3C%2FSTRONG%3E.%3C%2FP%3E%0A%3CP%3E2)%20Make%20sure%20that%20%3CSTRONG%3EShow%20Formulas%3C%2FSTRONG%3E%20in%20the%20%3CSTRONG%3EFormula%20Auditing%3C%2FSTRONG%3E%20group%20of%20the%20%3CSTRONG%3EFormulas%3C%2FSTRONG%3E%20tab%20of%20the%20ribbon%20is%26nbsp%3B%3CSTRONG%3Enot%3C%2FSTRONG%3E%20highlighted.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Using a Mac Safari 14.1.2 and Excel. Trying to input a formula

=SUM(D5:F5) and enter and all I see is the formula, not the actual sum. WTF

2 Replies

@Dr_Eddie_B120 

1) Make sure that the cell with the formula is not formatted as Text.

2) Make sure that Show Formulas in the Formula Auditing group of the Formulas tab of the ribbon is not highlighted.

Thanks.