Forum Discussion
Mel68
Jun 04, 2024Copper Contributor
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?
Could you please share the formula and clarify if it works in all rows but 1934.
- Mel68Copper ContributorHello Sergei - The formula is +G120-D121+F121. The formula worked fine on all lines prior to 1934. After that I get the #VALUE! response.
- Mel68Copper ContributorInterestingly I just manually calculated the correct result and inserted the number on line 1934. After that the formula works fine on all succeeding lines.
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.