Formula in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2503146%22%20slang%3D%22en-US%22%3EFormula%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2503146%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20typing%20my%20formula%20in%20Excel%20(%3DO2%2F(%24O%2416)%20and%20it%20just%20displays%20the%20formula%20...%20not%20the%20answer.%3C%2FP%3E%3CP%3EScreenshot%20attached.%20What%20am%20I%20doing%20wrong%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJen%20Jezylo%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2503146%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2503227%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2503227%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1092366%22%20target%3D%22_blank%22%3E%40Jezylo01%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EScreenshot%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E1)%20Make%20sure%20that%20the%20cell%20with%20the%20formula%20is%20formatted%20as%20General%2C%20not%20as%20Text.%3C%2FP%3E%0A%3CP%3E2)%20Make%20sure%20that%20the%20'Show%20Formulas'%20button%20in%20the%20'Formula%20Auditing'%20group%20of%20the%20Formulas%20tab%20of%20the%20ribbon%20is%20%3CSTRONG%3Enot%3C%2FSTRONG%3E%20highlighted.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I'm typing my formula in Excel (=O2/($O$16) and it just displays the formula ... not the answer.

Screenshot attached. What am I doing wrong?

 

Jen Jezylo

2 Replies

@Jezylo01 

Screenshot?

 

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

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

Thank you! Don't I feel silly.