Forum Discussion

Mel68's avatar
Mel68
Copper Contributor
Jun 04, 2024

Excel Formula No longer working (PC)

I've been using a simple formula to track my bank balance for years. Suddenly this simple addition and subtraction formula is no longer working on line 1934. Result is "#VALUE" instead of the calculation. 

 

I thought that I might have exceeded the number of usable lines in a single worksheet so I made a copy and tried deleting all but the last 300 or so lines. Same result. How do I fix this?

Formulas and Functions
    • Mel68's avatar
      Mel68
      Copper Contributor
      Jun 04, 2024
      Hello Sergei - The formula is +G120-D121+F121. The formula worked fine on all lines prior to 1934. After that I get the #VALUE! response.
    • Mel68's avatar
      Mel68
      Copper Contributor
      Jun 04, 2024
      Interestingly I just manually calculated the correct result and inserted the number on line 1934. After that the formula works fine on all succeeding lines.
      • SergeiBaklan's avatar
        SergeiBaklan
        MVP
        Jun 04, 2024

        Mel68 

        Great to know you sorted this out, thank you for the update.

        Most probably you had text instead of number in one of the cells used in formula.

Resources