Excel Formulas not working

[kare4]

We have an Excel workbook with about 27 worksheets which in themselves contain separate sheets. In one of the imbedded sheets, an invoice, the formulas are not working whereas in the other identical sheets it is fine. The cells are formatted as General, when clicking on a cell where the issue lies the formula is showing in the Formula Bar. I am not Excel savvy i only know the basics of navigating the workbook, I have tried online suggestions none seem to apply. TIA

[#2]

@kare4 

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/

[#3]

@victoriyaluna 

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? 

[#4]

@kare4 

Just found out the cause of the above stated problem which is self inflicted. The text was white against a white background hence could not see anything, I can imagine how stupid that must sound to you techies!! Sorry to waste your time. 

[#5]

@victoriyaluna thanks a lot - that was a quick fix that I was skeptical at first but definitely did the trick.