[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 more ideas to pay attention too: cell format set to text, and finally, every once in a while, see more.
Why are my formulas not showing up in Excel?
There’s a setting that makes Excel display formulas only instead of their results. This setting might have been enabled in your spreadsheet somehow. To change it back, use this shortcut: If an empty cell is formatted as text, then when you type the formula and hit enter, it will never show the result.
The formula is entered but the formula is displayed instead of the result. A cell in an Excel worksheet can have many formats and the default format of all cells in a new sheet is General (which would not cause this problem). Hence, a possible reason could be that the cell in which the formula is entered is formatted as Text. What’s the fix?
Every once in a while, you might find Excel behaving in a bizarre or unexpected way. One example is when you accidentally trigger the scroll lock feature. Another example is when one or more formulas suddenly stops working.
How do I show the result of a formula in Excel?
Select the cell. Format the cell as “General”. (Right-click the cell, select Format Cells, and choose “General.”) Delete the “=” at the beginning of your formula, and hit Enter. Insert the “=” back in the formula at the beginning. That is it. You should now see the result of the calculation in the cell rather than the text of the formula.
How to recover calculated formulas in Excel without the result?
You can try Stellar Repair for Excel software to recover engineering and shared formulas. Sometimes, when you type a formula in a cell of worksheet and press Enter, instead of showing the calculated result, it returns the formula as text. For instance, Excel cell shows: Why Does Excel Show or Display the Formula Not the Result?