A special setting is enabled Theres a setting that makes Excel display formulas only instead of their results.

Why my formula in excel not showing result. To turn that option OFF you just have to go to Formulas tab and under Formula Auditing turn off Show Formulas button. Check to see if show formulas is clicked on the data ribbon make sure the cell is formatted to general this should be in the home ribbon. Formula result is not showing formula visible in cell 1.

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. This video describes how to solve the very annoying issue of excel formulas showing but not the result. The cell still displays the formula.

There is a space before your Formula. You might also run into drag-to-fill issues if youre filtering. The cells are formatted as text before the formula is written.

Personally Ive struggled many times with these type of errors. It may help to delete and renter the last character of the formula. I open the fx function arguments helper and it shows that the result of the formula should be 1.

You may have accidentally pressed CTRL back quote symbol the key below escape key in your keyboard or activated the Show Formulas mode in Excel. In that case you will need to check the formula for any errors and correct. 2 Accidentally Typed the keys CTRL.

When using the Evaluate Formula function F9 it only does a one time calculation and is able to give a complete result. In simple terms your formula range is in an endless loop or its in a circle. If youre still having an issue with drag-to-fill make sure your advanced options File Options Advanced have Enable fill handle checked.