Lỗi not trying to type a formula excel năm 2024
Once in a while everyone is bound to come across this problem. You type a formula in a cell, then you press ENTER. Bam! nothing happens. You check if a donut chunk went in to the key board and some how jammed the ENTER key. So press it again, this time harder. But nothing. Excel formula showing as text instead of actual result, like this: Show
Now what to do? Of course, you can be careful when eating donuts. But careful donuts sure sounds like a paradox. So instead lets roll up our sleeves and find out the reason for this mishap. The top reason for Excel formula showing as text :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. When you do it, excel shows the formulas instead of their results. To fix this error and get back the values (or results) just press CTRL+` again or click on the “Show formulas button” The next reason why formulas are shown as formulas:You may have set the cell formatting to “Text” and then typed the formula in it. When you set the cell formatting to “Text”, Excel treats the formula as text and shows it instead of evaluating it. To fix this error, just select the cell, set its formatting to “General”. Now edit the formula and press enter. (Alternatively you can press F2 and then Enter after setting format to General). The less probable reason why formulas are shown as formulas instead of values:You may have accidentally typed a single quote ‘ before the = sign in the formula. When you type single quote ‘ in a cell excel treats the cell contents as text and does not evaluate any formulas within. To fix this error, just remove the single quote. What is your experience with excel formula errors?The very first time I pressed CTRL+` by accident, it nearly freaked me out. All the columns became too wide and the formatting went for a toss. Everything looked weird. It took me a while to figure out that I accidentally pressed the Show Formulas shortcut (CTRL+`). I felt huge relief when I got the results back. What about you? Did the formula error ever freaked you out? What other things about formulas worry you? Pls. share using comments. More on Formula Debugging:
Share this tip with your colleagues Get FREE Excel + Power BI TipsSimple, fun and useful emails, once per week. Learn & be awesome.
Welcome to Chandoo.orgThank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME. Read my story • FREE Excel tips book Excel School made me great at work. 5/5 From simple to complex, there is a formula for every occasion. Check out the list now. Calendars, invoices, trackers and much more. All free, fun and fantastic. Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here. Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch. Related Tips334 Responses to “Excel formula showing as text instead of actual result – How to fix the problem”
Rebekah says: All of these still did not solve my problem, and then I wondered if it is because I have iterative calculations enabled (I need that for another part of the worksheet). I switched it off and it solved my issue. (It's under Excel Options > Formulas.) So to do calculations I need to turn this off, then turn it back on again afterwards. |