Troubleshooting: Formula not Calculating

XLNS | See steps how to fix issues when your formulas are not working in Excel

Updated over a week ago

Problem

A cell displays the formula, not the result.


Solution

Here are different reasons why the excel formula is not calculated:


Troubleshooting

1. The formula is entered as a text

One of the main reasons why Excel formulas or not calculating is that the cell has been formatted as text.

To validate the setting, select the formula cell

  • Go to Home tab> Number format

  • Change the cell format to General. Click the cell and enter the formula to recalculate and display the value

Here’s a clip on how to change the cell format to display the calculated value:

2. The formula has a leading space or apostrophe before the equal sign

If you have a space or apostrophe entered before the equal sign, it will be treated as a text and will not calculate the formula.

To fix, just simply remove the leading space or single quote.

Did this answer your question?