Forum Discussion
Excel Formulas not working
If your formula appears in the formula bar then I guess you have this problem- Excel formula showing as text instead of the actual result.
The top reason for Excel formula showing as text is you may have accidentally pressed CTRL+` (backquote symbol, the key below escape key in your keyboard) or activated the “Show Formulas” mode in Excel. To fix this error and get back the values (or results) just press CTRL+` again or click on the “Show formulas button” to disable if enables.
If you still face the error then check these guides to know more reasons for solutions.
References- https://chandoo.org/wp/excel-formulas-are-not-working/
https://www.stellarinfo.com/blog/excel-formula-not-showing-result/
victoriyaluna thanks a lot - that was a quick fix that I was skeptical at first but definitely did the trick.
Thank you for your response.
The result cells are completely blank no text or anything else. I am just wondering if the format was 'cleared' from these particular cells would that have made a difference?
