Forum Discussion
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 calcula...
Could you please share the formula and clarify if it works in all rows but 1934.
- 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.
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.
- Thanks. I'll take another look at the source cells for the formula.
- 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.
