[Solution] Excel Formula Shows Formula but not Result
No equal sign. First, you may have forgotten the equal sign. Space before equal sign. A subtle variation of this problem can occur if there is one Formula wrapped in quotes. Finally, make sure the formula is not wrapped in quotes. A few extra ideas to examine: finally, every once in a while, see more, and cell format set to text.
Why is my formula not showing up in Excel?
Finally, every once in a while, you might see a formula that is well-formed in every way, but somehow does not display a result. If you run into a formula like this, check to see if the cell format is set to Text.
The next reason why formulas are shown as formulas: You may have set the cell formatting to “Text ” and then typed the formula in it. When you set the cell formatting to “Text”, Excel treats the formula as text and shows it instead of evaluating it. To fix this error, just select the cell, set its formatting to “General”.
Therefore, if you enter a formula that links one cell to a cell formatted as text, the cell with the formula is also formatted as text. To display the calculated value rather than the formula, you must change the format of the cell containing the formula and re-enter the formula.
Here is what we found. excel has a feature called Show Formulas that toggles the display of formula results and actual formulas. Show Formulas is mean to give you a quick way to see all formulas in a worksheet. However, if you accidentally trigger this mode, it can be quite disorienting.
Why are my formulas not showing up as text in Excel?
Click the Formulas tab. In the Formula Auditing group, click on Show Formulas. The keyboard shortcut to enable/disable showing formulas as text options is Control + `. In most cases, this should fix the problem and your formulas should show the result and not show up as text itself .
Our favorite answer was When you set the cell formatting to “Text”, Excel treats the formula as text and shows it instead of evaluating it. To fix this error, just select the cell, set its formatting to “General”. Now edit the formula and press enter. (Alternatively you can press F2 and then Enter after setting format to General).
Why do we need to edit the formula in Excel?
The reason for editing the formula is that formatting the cell to General will not have any impact on the cell’s existing contents. Similarly, if you already had the result of your formula and later the cell is formatted to Text, it will not change to the formula in text.