Formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-2265533%22%20slang%3D%22en-US%22%3EFormulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2265533%22%20slang%3D%22en-US%22%3E%3CP%3EAll%20my%20formulas%20in%20all%20worksheets%20are%20not%20working.%26nbsp%3B%20Did%20I%20accidentally%20change%20a%20setting%20somewhere%3F%26nbsp%3B%20%26nbsp%3BFor%20example%2C%20I%20have%20a%20spreadsheet%20with%20a%20prior%20balance%20column.%26nbsp%3B%20I%20also%20have%20a%20Charges%20column%20and%20a%20Payments%20column.%26nbsp%3B%20The%20current%20Ending%20Balance%20formula%20is%20%3DSum(C17%2BD17-E17).%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2265533%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2265549%22%20slang%3D%22de-DE%22%3ESubject%3A%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2265549%22%20slang%3D%22de-DE%22%3EWithout%20the%20file%20it%20is%20difficult%20to%20come%20up%20with%20a%20solution.%3CBR%20%2F%3ETherefore%2C%20with%20your%20permission%2C%20I%20recommend%20that%20you%20insert%20the%20file%20(without%20sensitive%20data).%3CBR%20%2F%3EIn%20this%20way%20you%20can%20reproduce%20the%20error%20and%20come%20up%20with%20a%20proposal%20%3CBR%20%2F%3E%20for%20a%20solution%20that%20might%20suit%20you%20more%20quickly.%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20for%20your%20understanding%20and%20patience%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E
New Contributor

All my formulas in all worksheets are not working.  Did I accidentally change a setting somewhere?   For example, I have a spreadsheet with a prior balance column.  I also have a Charges column and a Payments column.  The current Ending Balance formula is =Sum(C17+D17-E17).  

2 Replies
Without the file it is difficult to come up with a solution.
Therefore, with your permission, I recommend that you insert the file (without sensitive data).
In this way you can reproduce the error and come up with a proposal
for a solution that might suit you more quickly.

Thank you for your understanding and patience

Nikolino
I know I don't know anything (Socrates)
Thanks so much. Somehow the formula calculation got changed from Automatic to Manual. Right after posting, I discovered that change.