Learn how to fix Excel errors showing formulas not displaying results
At present, Excel is an indispensable software in many fields. However, being able to use this software fluently is not simple. This is also the reason why many people have difficulty working in Excel. In today's article, we will learn together about Excel displaying formulas without displaying results . This is an error that has caused headaches for many Excel users, especially those who are new to Excel.
Why does Excel show formulas but not results?
Even though I entered the correct formula, the results did not come out. This is a common problem that many Excel users encounter. Contrary to what many people think, the cause of this problem is quite simple.
As far as I know, the error of not displaying a value in Excel is mostly due to errors in the process of entering the formula. At this point, the Excel system will understand that your formula is in text form. From there it will not calculate the results based on the formula you entered. Below are some factors that can cause Excel to recognize that your formula is in text format.
1: You are turning on the Show Formulas feature
In Excel there is a feature called Show Formulas. This feature is located in the Formulas tab and has a keyboard shortcut of 'Ctrl+`'. When you accidentally enable this feature. Any formulas in Excel will be displayed instead of results. However, if only one cell has a formula showing but no results, it is definitely not due to this feature.
2: Missing '=' sign in formula
As you know, all formulas in Excel will start with an '=' sign. So when you enter the formula and accidentally forget the '=' sign at the beginning. At this point, the system will think the data you entered is simply text, not a formula.
3: The formula is in quotes
In case you have entered the '=' sign before the formula but still no results. This is most likely because your formula has been enclosed in quotes. Similar to above, Excel will now understand your formula as text.
4: At the beginning of the formula there are parentheses
The last case is that there are parentheses before your formula. And of course in this case, Excel will still consider the formula as text. Therefore, no matter how many times you enter, the answer still does not appear.
How to check formula errors in Excel
To determine whether your formula is in text format or not is very simple. Now we will use the ISTEXT function with the formula = ISTEXT (cell to be determined) . If the result of this formula is TRUE , it means your formula is in text format. At this point, you should rely on the signs I mentioned above to fix it. If the result appears as FALSE , it means your cell contains a formula.
Note
In some cases, if your Excel file is too heavy. There is a high possibility that the computer is not powerful enough to work and causes delays in the calculation process. This makes many people confused that they entered the correct formula but got no results.
In this case, it is best to try restarting the computer and then reopening the Excel file. If it still doesn't work, try sending the file to someone to open it and see what happens!
And above is information about Excel displaying formulas without displaying results. Hopefully this information will help you quickly handle errors when working on Excel software.
You should read it
- How to Copy Formulas in Excel
- What is ### error in Excel? how to fix ### error in Excel
- Steps to fix the error showing the search results table on Windows 10 continuously
- Fix Excel Error Not Showing Spreadsheet At A Glance
- Instructions for hiding formulas in Excel
- How to hide formulas in Excel
- MS Excel - Lesson 5: Excel formulas and functions
- How to display formulas and print formulas in Excel
May be interested
- How to convert PDF files to PowerPointpdf is one of the most used file formats in the world. however, it's not easy to use pdf in powerpoint presentations. this article will show you how to convert pdf files to ppt and provide some formatting tips.
- How to check if Microsoft Office version is 32-bit or 64-bitnot only you, but many other users who are using the microsoft office program also don't know whether the office version they are using is 32-bit or 64-bit. if you want to know or need to know whether the office version you are using is 32-bit or 64-bit, please refer to the steps in the article below from network administrator.
- Latest Free Update Office 2010 Key 2024using the latest office 2010 key is the most effective method for users to activate the copyright and use all functions. with the permanently licensed office 2010 keys shared by taimienphi below, it will help you do that.
- PowerPoint 2016: Animate text and objectswhat is animation pane in powerpoint? how to create effects in powerpoint 2016? let's learn with tipsmake.com.com how to create effects for text and objects in powerpoint!
- Number pages in Word 2013, insert page numbers automaticallyto number pages on word 2013, we also perform the same operation as when numbering pages on word 2007, or numbering pages on 2010.
- Not everyone knows how to use ChatGPT to have more free timewith the development of ai (artificial intelligence), you can use chatgpt to have more free time to do other things.