Excel will not perform computations correctly

Question

Excel will not perform computations correctly

Bill Moorhead 0

cannot get Excel to do computations correctly. Have double checked formulae; that is not the issue.

John Jefferson Doyon 86,980 Reputation points Independent Advisor

2026-08-18T22:16:32.46+00:00
Hi, @Bill Moorhead

If the formulas are correct, the next step is to determine whether this is a calculation setting, data format, or workbook issue.

To help narrow down the issue:

Can you give one example formula, the result Excel gives, and the result you expect?

Does the same problem happen in a brand-new blank workbook?

In Excel, go to Formulas > Calculation Options. Is it set to Automatic or Manual?

Also, are the affected cells formatted as numbers, or could the values have been imported/stored as text?

Click "Add comment" to let me know.

Thanks!

1 answer

Your answer

John Jefferson Doyon 86,980 Reputation points Independent Advisor

2026-08-18T22:16:32.46+00:00

Hi, @Bill Moorhead

If the formulas are correct, the next step is to determine whether this is a calculation setting, data format, or workbook issue.

To help narrow down the issue:

Can you give one example formula, the result Excel gives, and the result you expect?

Does the same problem happen in a brand-new blank workbook?

In Excel, go to Formulas > Calculation Options. Is it set to Automatic or Manual?

Also, are the affected cells formatted as numbers, or could the values have been imported/stored as text?

Click "Add comment" to let me know.

Thanks!

Answer 1

If the formulas are correct but Excel is still not calculating correctly, check these common causes:

Make sure the formula starts with =. If not, Excel can treat it as text instead of calculating it.
Check whether the cell is formatted as Text. If formulas display as text or do not evaluate:
- Select the cell
- Go to Home > Number Format
- Change it to General
- Press F2, then Enter
Make sure Show Formulas is turned off:
- Go to Formulas > Show Formulas
Check calculation mode:
- Go to Formulas > Calculation Options
- Set it to Automatic
- To force recalculation, use Calculate Now, or press F9 or Shift+F9
Check for common formula entry issues even if the formula looks right:
- Mismatched parentheses
- Missing required arguments
- Wrong argument type
- Wrong range separator, such as using a space instead of :
- Wrong list separator for the regional setting, such as , instead of ;
If Excel shows an error like #VALUE!, #REF!, #NAME?, or #DIV/0!, that points to a specific formula problem. If the cell shows #####, that usually means the column is too narrow, not that the formula is broken. Fix that with Home > Format > AutoFit Column Width.
Turn on background error checking:
- Windows: File > Options > Formulas
- Mac: Excel menu > Preferences > Error Checking
- Enable Enable background error checking
- Excel will mark problem cells with a triangle in the top-left corner

If the issue is that Excel shows the formula itself instead of the result, the most likely causes are Text cell format, Show Formulas being enabled, or calculation mode not being Automatic.

References: