In simple terms your formula range is in an endless loop or its in a circle.
Why my formula in excel not showing result. The steps in this tutorial will assume that your formula is correct and that an option in Excel has simply been changed which displays formulas instead of their results. Try removing all filters and dragging again. You may have explicitly formatted them as text but more often it is a download or import from another system and the system has made all cells text.
There are two main reasons you might see a formula instead of a result. Click the Number tab. If you do so circular reference errors would show up.
Personally Ive struggled many times with these type of errors. If it is all formulas in your sheet will be visible and not their results. It may help to delete and renter the last character of the formula.
The top reason for Excel formula showing as text. If you are seeing something in your cell other than the formula or its result such as NA then this typically indicates that there is a problem with the formula. A special setting is enabled Theres a setting that makes Excel display formulas only instead of their results.
2 Accidentally Typed the keys CTRL. This video describes how to solve the very annoying issue of excel formulas showing but not the result. The reason for Excel showing formula not result.
I have a VBA program that inserts the following formula into my excel spreadsheet and in many of my cells the result should be 1 but it isnt showing up. In that case you will need to check the formula for any errors and correct. I tried changing the font color to black I tried changing it to bold or italic it just wont show up.