There could be multiple reasons behind Excel showing formula instead of the result , and in this tutorial, I will show you the potential fixes that will make this issue go away.
In most cases, this should fix the problem and your formulas should show the result and not show up as text itself. Another issue that you may face is that when you insert a formula, it shows the formulas and not the value. Note that when you apply text formatting to a cell, it will only show formulas as a text for the formulas you enter after applying the formatting. 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:. You'll see you can quickly toggles all formulas on and off. Show Formulas toggles the display of every formula in a worksheet. If you are having trouble with a single formula, the problem isn't Show Formulas. Instead, Excel probably thinks the formula is text. Read on for more information. If Excel thinks a formula is just text, and not an actual formula, it will simply display the text without trying to evaluate it as a formula.
There several situations that might cause this behavior. First, you may have forgotten the equal sign. If you leave this out, Excel will simply treat the formula as text:. A subtle variation of this problem can occur if there is one or more spaces before the equal sign. A single space can be hard to spot, but it breaks the rule that all formulas must start with an equal sign, so it will break the formula as shown below:.
Finally, make sure the formula is not wrapped in quotes. Sometimes, when people mention a formula online, they will use quotes, like this:. Note: you are free to use quotes inside formulas. In this case, the formula above requires quotes around criteria. In all of the examples above, just edit the formula so it begins with an equal sign and all should be well:.
Approved By Alexis Llontop. Min Reading 5 Min. This blog explains the possible reasons behind such an issue. 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:. Instead of applying calculations and then showing results, this feature displays the actual text written by you. Another possible reason that only formula shows in Excel not result could be that the cell format is set to text.
This means that anything written in any format in that cell will be treated as regular text. If so, change the format to General or any other. To get Excel to recognize the change in the format, you may need to enter cell edit mode by clicking into the formula bar or just press F2. This issue is not easily detected because it results in calculating formula in one cell but if you copy it to some other cell, it will retain the first calculation and will not recalculate on the base of the new location.
To fix this, follow these steps:. There is a proper way to tell Excel that your text is a formula. For this reason, keep the following in mind when typing a formula:. In an Excel formula, a comma is used to separate arguments of a function and a dollar sign makes an absolute cell reference.
0コメント