Check the cell first. If it shows the formula text, fix Text formatting or remove a leading apostrophe; if results are stale, switch calculation back to Automatic; if a copied formula breaks, check separators and cell references. Leaving it unchecked can leave reports wrong and formulas frozen. This guide gives you an about two-minute triage flow for text entries, manual calculation mode, and copied-formula errors.

Quick fixes for text and calculation issues

Why Excel shows the formula instead of the answer?
A webpage shows an Excel screenshot with a formula displayed instead of a result

If a formula appears in the cell instead of a result, Excel is treating the entry as text or showing formulas on purpose. Start by checking Show Formulas mode, then the cell format, then whether the entry begins with an apostrophe or lacks an equals sign.

Formula shows as text vs formula calculates incorrectly

symptom likely cause quickest check fix whether to re-enter the formula
Cell displays =SUM(A1:A10) as text Cell format is Text Home > Number Format shows Text Change to General, then re-enter Yes
Formula starts with an apostrophe Leading apostrophe forces text Look in the formula bar for '= Delete the apostrophe and confirm with Enter Yes
Entry does not calculate at all Missing equals sign Check the first character Add = at the start Yes
Only one workbook stays stale Manual calculation Formulas > Calculation Options Switch to Automatic or use Calculate Now No
Copied formula returns a different range Relative references shifted Compare the copied formula with the original Edit ranges or lock them with $ Sometimes
A copied SUMIF or SUMIFS stops parsing Comma vs semicolon mismatch Check the separator used in the formula Match the workbook’s locale separator Usually
Formula returns the wrong row or match Lookup key changed or is dirty text Compare exact text and number formatting Clean the key, then recalculate Sometimes
Formula should work but a sheet still looks old Stale cached results Press Calculate Now Force a workbook recalc No

How to read the symptom table

Start with what you see in the cell, not the formula text. If Excel shows text, the entry is usually not being parsed as a formula; if the formula calculates but the result is wrong or stale, the problem is usually calculation mode, references, or lookup logic. That split saves time.

  1. Look at the cell, not just the formula bar.
  2. Check whether the cell shows text or an outdated result.
  3. Pick the matching fix path from the table.
  4. Only rewrite the formula after the display and calculation checks fail.

What should you check first when an Excel formula does not calculate?

Check the entry format first, then calculation mode, then copied references. Those three causes are the fastest wins because a formula can be valid and still fail to return a result. A formula that looks fine may be text, may be blocked by manual calculation, or may point at the wrong cells after a paste.

Likely causes, in the right order

  1. Text formatting or a leading apostrophe.
  2. A missing equals sign or invisible character before it.
  3. Manual calculation mode and stale results.
  4. Copied formulas with shifted references or wrong separators.
  5. Logic problems in SUMIFS, COUNTIFS, lookups, or date comparisons.

Is the cell formatted as text?

A Text-formatted cell can display a formula instead of evaluating it, and changing the format alone is not enough if the formula is already stored as text. After you switch the cell to General, re-enter the formula so Excel parses it again. This is a common fix for formulas that visibly start with an equals sign but still do not calculate.

  1. Select the cell or range.
  2. Go to Home > Number Format and change Text to General (per Microsoft support).
  3. Click in the formula bar, then press F2 and Enter to re-enter the formula.
  4. If the formula still shows as text, delete it and type it again with the leading =.

Say your formula is =A1+B1 in a sales sheet, but the cell still shows the formula text after you change the format. Re-entering it is the difference between a stored text string and a real calculation. One format change is not enough if the old text is still there.

Why won't your formula calculate?

If the formula is valid but results are stale, the workbook is often in manual calculation mode. In that state, Excel does not update formulas immediately, so one sheet or the whole workbook can look frozen until you force a recalc. Use Calculate Now as a quick test before rewriting the formula.

Check calculation mode

  1. Open Formulas > Calculation Options.
  2. Choose Automatic if it is set to Manual (per Microsoft support).
  3. Use Calculate Now to refresh the workbook if you want a test before changing settings.
  4. Save, then reopen the file to confirm the result updates.

Suppose a quarterly workbook updates one sheet but leaves another one unchanged after you edit an input cell. That pattern points to stale cached results rather than a broken formula. Manual calculation can do that, and Calculate Now is the quickest way to separate stale output from a formula error.

Use Calculate Now to force a refresh

  1. Press F9 for a workbook recalculation.
  2. Use Formulas > Calculate Now if the shortcut does not refresh the visible result.
  3. If the result changes only after this step, leave the workbook in Automatic.
  4. If only one worksheet stays stale, check that sheet for circular references or pasted formulas that point elsewhere.

Did copying change the formula?

Did copying change the formula?
An Excel formula example shows copied cell references and salary values

Copied formulas can shift relative references, and that shift is easy to miss after a paste between files or locales. A formula can still be syntactically valid while pointing at the wrong range, and copied SUMIF or SUMIFS formulas can also break if the separators do not match the destination workbook’s locale.

Watch for shifted relative references

  1. Compare the original formula with the copied one in the formula bar.
  2. Check whether ranges moved from A1:A10 to a different row or column block.
  3. Lock ranges with $ where the range should not move.
  4. Paste only after confirming the destination sheet uses the same structure.

Microsoft lists the colon operator as the range reference in a formula such as SUM(B5:B15), so a small shift in that reference can change the total immediately. The formula may still run; it just runs against the wrong cells. (Microsoft Support)

Check comma and semicolon separators

  1. Inspect a copied SUMIF or SUMIFS formula for commas or semicolons.
  2. If the workbook expects semicolons, replace commas with semicolons.
  3. If the workbook expects commas, remove semicolons and paste the formula again.
  4. Confirm the formula parses after the separator change.

Excel uses comma-based syntax in some workbooks and semicolon-based syntax in locale-based workbooks. A copied formula from a different locale can look correct but fail because the argument delimiter is wrong. That is a parsing problem, not a math problem.

What should you check next?

What should you check next?
An Excel tutorial graphic shows checkboxes and a task status table

When the formula parses but the result is still wrong, look at circular references, SUMIFS and COUNTIFS range alignment, and exact-match lookups. These failures are common because the formula is valid, yet the logic is off. Date formulas also fail when the underlying cells are stored as text or the comparison key is dirty.

Circular references

  1. Go to Formulas > Error Checking and look for circular reference warnings.
  2. Check whether the formula points back to its own cell or to a dependent chain that returns to it.
  3. Remove the self-reference or move the calculation to a separate helper cell.
  4. Recalculate the workbook after the fix.

A circular reference can be intentional in some models, but it can also be accidental after a copy or insert. If the result never settles, this is one of the first logic checks to make.

SUMIFS and COUNTIFS range matches

  1. Open the formula and compare every criteria range against the sum or count range.
  2. Make sure the ranges cover the same rows and start on the same row.
  3. Check for accidental blank rows or shortened ranges after copying.
  4. Correct the range mismatch, then press Enter and recalculate.

SUMIFS and COUNTIFS can fail quietly when the criteria ranges do not match the main range. The formula may return a number, but it will be the wrong number.

Exact-match lookup keys and date or number formats

  1. Check the lookup value for hidden spaces, leading zeros, or text-number mismatch.
  2. Compare the source key and the lookup table key character for character.
  3. Confirm dates are real date values, not text that only looks like dates.
  4. Re-enter the lookup key or convert the source column to a consistent format.

Exact-match lookups depend on identical keys. A space at the end, a text-formatted number, or a date stored as text can stop the match even when the cells look the same on screen.

Keep reading

Frequently asked questions

Why is my formula not showing in Excel?

Check whether Show Formulas is on first. Use Ctrl+` to toggle it off, or go to File > Options > Advanced and clear the Show formulas option (per Microsoft support). If it is still shown as text, switch the cell format from Text to General and re-enter the formula.

Why in Excel formula not calculating?

Start with Formulas > Calculation Options > Automatic. If the workbook is on Manual, press F9 or Formulas > Calculate Now. If that updates the result, the formula is probably fine and the workbook was just not refreshing.

Why won't my Excel formula calculate?

Check the first character and the cell format. A formula should begin with =, and a cell formatted as Text can store it as text instead of evaluating it. If the formula was copied, compare the references and separators before rewriting it.

Why is my Excel sum formula not working?

For SUMIFS or COUNTIFS, verify that every criteria range matches the main range in size and row alignment. Then check whether the copied formula uses commas or semicolons. A single separator mismatch can stop the formula from parsing.

Why are my Excel formulas not updating automatically?

Automatic updates stop when Formulas > Calculation Options is set to Manual. Change it back to Automatic, then use Calculate Now once to clear stale results. If one sheet still lags, check for a circular reference or a pasted formula that points to the wrong cells.