Formula is one of the most commonly-used features in Excel. However, some people report that their formulas don’t calculate or work. This post from MiniTool Partition Wizard tells you why the Excel formula not calculating issue occurs.

In general, if the Excel formula doesn’t work or calculate, you may face the following cases:

  • The Excel cell shows formula instead of result.
  • The Excel formula doesn’t show the new result after the values of the dependent cells have been changed.
  • The formula returns an error or wrong result.

Why does the Excel formula not calculating/working issue occur? How to solve this issue? The following content will show you all.

Reason 1. Show Formulas Mode Is Turned on

One of the reasons for the Excel showing formula instead of result issue is the Show Formulas mode. To turn off this mode, you can click the Formulas tab and then click the Show Formulas button in the Formula Auditing section. 

Excel Ran out of Resources While Attempting to Calculate Formulas
Excel Ran out of Resources While Attempting to Calculate Formulas

This post is for the issue “Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas cannot be evaluated”.

Read More

Reason 2. The Formula Is Entered as Text

If the formula has been formatted as text, the Excel formula not calculating issue will also occur. To check that, you can do as follows:

  1. Select the formula cell.
  2. Go to the Home tab > Number section.
  3. Make sure that the drop-down menu selects the Number option.

Reason 3. A Space or An Apostrophe Is Entered Before the Equal Sign

If you have inadvertently entered a space or apostrophe before the equal sign, Excel treats the cell contents as text. Then, the Excel not calculating formulas issue will occur. You need to delete the space or the apostrophe.

How to Fix Filter Not Working in Excel [3 Cases]
How to Fix Filter Not Working in Excel [3 Cases]

This post introduces 3 cases where the Filter feature doesn’t work and tells you how to solve this issue.

Read More

Reason 4. The Calculation Setting Is Set to Manual

If the Calculation setting has been changed to Manual instead of Automatic, the Excel formulas not working issue will occur. To set the Calculation option to Automatic again, you just need to go to the Formulas tab > Calculation group, click the Calculation Options button, and select Automatic.

Reason 5. The Formula Is Not Correct

One of the most common reasons for the formulas not working in Excel issue is that the formula is not correct. For example:

  • Your formula is short of one or more parentheses.
  • You have nested more than 64 functions in a formula.
  • You have enclosed numbers in double quotes.
  • You have added decimal separators or currency signs to the numbers.
  • You have separated function arguments with an improper character.
  • And Others.

To solve this issue, you just need to standardize the use of formulas.

How to Fix Excel VLOOKUP Not Working [4 Cases]
How to Fix Excel VLOOKUP Not Working [4 Cases]

The VLOOKUP function is an important feature in Excel. This post introduces 4 cases of VLOOKUP not working and offers corresponding solutions.

Read More

Bottom Line

MiniTool Partition Wizard is a functional tool. It can convert MBR to GPT without data loss, migrate OS, clone hard drive, recover partitions, recover data from hard drive, etc. If you have this need, download it to have a try.

MiniTool Partition Wizard DemoClick to Download100%Clean & Safe

  • linkedin
  • reddit