NOT WORKING FORMULA

Emax India 0 Reputation points
2026-10-12T11:05:27.7466667+00:00

DEAR MICROSOFT TEAM SOME FORMULAS IN

EXCEL SOFTAWRE NOT WORKING PROPERLY SO WHAT TO DO

Microsoft 365 and Office | Excel | Other | Windows
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. TaoLi 115.4K Reputation points Independent Advisor
    2026-10-12T11:58:25.5633333+00:00

    Hi, if your formula results aren’t updating, try File >> Options >> Formulas >> Workbook Calculation >> Automatic, then click OK.

    If the issue continues, please paste one affected formula, the result or error it shows, and the result you expected. Also share your Excel version from File >> Account so I can suggest the right fix.

    Was this answer helpful?

    0 comments

  2. AI answer

    2026-10-12T11:05:42.6866667+00:00

    Try this checklist in Excel:

    1. Check the formula starts with =.
      • If the equal sign is missing, Excel may treat the entry as text instead of calculating it.
    2. Check parentheses.
      • Every opening parenthesis ( must have a matching closing parenthesis ).
    3. Check range references.
      • Use a colon for ranges, for example =SUM(A1:A5).
    4. Check function arguments.
      • Some functions require specific arguments and specific data types.
      • Example: UPPER accepts one text string or one cell reference.
      • Using the wrong type of value can return #VALUE!.
    5. Check the list separator used by Excel.
      • Some Excel installations use commas , and others use semicolons ; between arguments.
      • If a formula works in Excel for the web but not in desktop Excel, regional settings may be the cause.
      • Test with =SUM(1,2) or =SUM(1;2) and use the one that works.
    6. Evaluate the formula step by step.
      • Go to Formulas > Evaluate Formula.
      • Select Evaluate repeatedly to see which part of the formula is failing.
      • This is especially useful for long or nested formulas.
    7. Check for inconsistent formulas.
      • Go to Formulas > Error Checking.
      • If Excel flags an inconsistent formula, review it and correct it, or choose Ignore Error if it is intentional.
    8. Check for circular references.
      • A circular reference happens when a formula refers to its own cell directly or indirectly.
      • Example: in A10, using =SUM(A1:A11) can create a circular reference.
    9. If Excel hangs or becomes very slow with formulas, try manual calculation mode.
      • Go to Formulas > Calculation Options > Manual.
      • This helps check whether automatic recalculation is causing the issue.
    10. Check workbook content if only one file has the problem.
    • Performance and formula issues can be caused by formulas referencing entire columns, invalid defined names, or files generated by third-party applications.

    If the problem is with a specific formula, review the exact syntax, separators, arguments, and references first. For complex formulas, use Evaluate Formula to find the exact failing part.

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.