Symptoms : A cell displays the formula, not the result. If your Excel formula is not working because a cell displays the function instead of the calculated value, it’s because one of the following reasons. Show Formulas mode is turned on.
Why Excel is not calculating a result?
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.
Another frequently asked query is “Why is my sum formula not working in Excel?”.
One answer is that the below screenshot shows that even a simple Excel SUM formula may not work because of numbers formatted as text: To fix this, select all problematic cells, click the warning sign, and then click Convert to Number: In some cases, however, neither green triangles nor the warning sign appear in cells.
What happens when you enable show formulas in Excel?
With Show Formulas enabled, columns are widened, and every formula in a worksheet is displayed with no results anywhere in sight, as shown in the screens below. To check if Show Formulas is turned on, visit the Formula tab in the ribbon and check the Show Formulas button:.
This begs the inquiry “How do I turn off all formulas in Excel?”
If an Excel spreadsheet displays all its formulas within cells, the Show Formulas option is probably enabled. To disable that option, click the Formulas tab in Excel. Then click the Show Formulas button on that tab.
How do I show or hide calculations in Excel?
Show Formulas (Ctrl + ~) has been selected / pressed – If the Show Formulas option has been selected, calculations will show their full formula and not show the calculated results.