When using the Evaluate Formula function F9 it only does a one time calculation and is able to give a complete result.

Why my formula in excel not showing result. 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. The reason for Excel showing formula not result. 2 Accidentally Typed the keys CTRL.

Now lets look at the solutions for the reasons given above for the excel formula not. If youre still having an issue with drag-to-fill make sure your advanced options File Options Advanced have Enable fill handle checked. This video describes how to solve the very annoying issue of excel formulas showing but not the result.

The top reason for Excel formula showing as text. 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. The second reason why you see your formula instead of the result may be the Show Formulas option.

If it is all formulas in your sheet will be visible and not their results. Personally Ive struggled many times with these type of errors. To turn that option OFF you just have to go to Formulas tab and under Formula Auditing turn off Show Formulas button.

For example you type 255 and get 255 when you. You accidentally enabled Show Formulas Excel thinks your formula is text. It may help to delete and renter the last character of the formula.

In that case immediately check whether the cell format is set to text or not. In simple terms your formula range is in an endless loop or its in a circle. Formula result is not showing formula visible in cell 1.