Not calculating correctly

%3CLINGO-SUB%20id%3D%22lingo-sub-1864247%22%20slang%3D%22en-US%22%3ENot%20calculating%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1864247%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20needing%20some%20help.%26nbsp%3B%20My%20formula%20to%20subtract%20several%20cells%2C%20from%20one%20cell%20is%20not%20calculating%20correctly.%20I%20have%20been%20using%20the%20same%20formula%20on%20different%20lines%2C%20works%20perferct.%20I%20changed%20number%20values%2C%20no%20will%20only%20subtract%20one%20cell.%26nbsp%3B%20Help%20please.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3ETammy%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1864247%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1864265%22%20slang%3D%22en-US%22%3ERe%3A%20Not%20calculating%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1864265%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F861150%22%20target%3D%22_blank%22%3E%40tamrwolf%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20realize%2C%20I%20trust%2C%20that%20you've%20given%20insufficient%20information%20for%20anybody%20to%20say%20much.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20copy%20of%20the%20spreadsheet%2C%20so%20long%20as%20it%20contains%20no%20confidential%20information%2C%20would%20be%20the%20most%20helpful.%20Short%20of%20that%2C%20at%20least%20a%20copy%20of%20the%20actual%20formula%20in%20question%2C%20along%20with%20a%20description%20of%20what%20DOES%20happen.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20other%20thing%20I%20sort%20of%20feel%20compelled%20to%20say%20is%20this.%20You%20have%20written%2C%20%3CEM%3E%22My%20formula%20to%20subtract%20several%20cells%2C%20from%20one%20cell%20is%20not%20calculating%20correctly.%22%3C%2FEM%3E%20%3CU%3E%3CSTRONG%3EThe%20reality%20is%20that%20the%20%3C%2FSTRONG%3E%3CSTRONG%3E%3CU%3Eform%3C%2FU%3Eula%3C%2FSTRONG%3E%3C%2FU%3E--I%20feel%20entirely%20confident%20in%20saying%20this--%3CU%3E%3CSTRONG%3E%3CEM%3EIS%3C%2FEM%3E%20calculating%20correctly.%20%3C%2FSTRONG%3E%3C%2FU%3EIt%20may%20not%20be%20producing%20the%20result%20that%20you're%20expecting%2C%20but%20that%20really%20isn't%20because%20%22the%20formula%20isn't%20working%20correctly%22%3B%20Excel%20has%20been%20around%20long%20enough%2C%20used%20by%20millions%20of%20users%20around%20the%20globe%2C%20that%20the%20chances%20you've%20uncovered%20a%20hitherto%20unnoticed%20bug%20are%20less%20than%20infinitesimal.%20Instead%2C%20there's%20no%20doubt%20something%20in%20the%20way%20you've%20written%20it%20that%20causes%20it%20to%20produce%20an%20unexpected%20result--perhaps%20a%20relative%20reference%20that%20should%20be%20absolute%2C%20or%20vice%20versa%3B%20perhaps%20something%20else.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20challenge%2C%20therefore%2C%20is%20to%20figure%20out%20why%20it%20is%20accurately%20producing%20a%20result%20that%20doesn't%20match%20your%20expectations%2C%20which%20involves%20getting%20at%20what's%20wrong%20with%20how%20the%20formula%20is%20written.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20to%20answer%20that%2C%20you%20need%20to%20let%20us%20see%20the%20spreadsheet%20itself%20or%2C%20at%20the%20very%20least%2C%20a%20full%20copy%20of%20the%20formula%20in%20question%2C%20along%20with%20a%20description%20of%20what%20the%20various%20cell%20references%20contain%2C%20how%20you've%20copied%20it%20from%20row%20to%20row%2C%20etc.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1864266%22%20slang%3D%22en-US%22%3ERe%3A%20Not%20calculating%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1864266%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F861150%22%20target%3D%22_blank%22%3E%40tamrwolf%3C%2FA%3E%26nbsp%3B%2C%20Hello%2C%20it%20will%20be%20difficult%20for%20anyone%20to%20understand%20the%20problem%20you%20are%20facing%20without%20the%20specific%20details.%20People%20here%20would%20like%20to%20see%20the%20formula%20you%20are%20using%20and%20the%20cells%20on%20which%20you%20are%20applying.%20You%20may%20attach%20screenshots%20which%20describe%20above%2C%20or%20better%20still%2C%20attach%20the%20excel%20file%20itself%20in%20your%20post%20(after%20removing%20any%20sensitive%20or%20confidential%20info.)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am needing some help.  My formula to subtract several cells, from one cell is not calculating correctly. I have been using the same formula on different lines, works perferct. I changed number values, no will only subtract one cell.  Help please.

 

 

Thank you

Tammy

2 Replies

@tamrwolf 

 

You realize, I trust, that you've given insufficient information for anybody to say much.

 

A copy of the spreadsheet, so long as it contains no confidential information, would be the most helpful. Short of that, at least a copy of the actual formula in question, along with a description of what DOES happen.

 

The other thing I sort of feel compelled to say is this. You have written, "My formula to subtract several cells, from one cell is not calculating correctly." The reality is that the formula--I feel entirely confident in saying this--IS calculating correctly. It may not be producing the result that you're expecting, but that really isn't because "the formula isn't working correctly"; Excel has been around long enough, used by millions of users around the globe, that the chances you've uncovered a hitherto unnoticed bug are less than infinitesimal. Instead, there's no doubt something in the way you've written it that causes it to produce an unexpected result--perhaps a relative reference that should be absolute, or vice versa; perhaps something else.

 

The challenge, therefore, is to figure out why it is accurately producing a result that doesn't match your expectations, which involves getting at what's wrong with how the formula is written.

 

And to answer that, you need to let us see the spreadsheet itself or, at the very least, a full copy of the formula in question, along with a description of what the various cell references contain, how you've copied it from row to row, etc.

@tamrwolf , Hello, it will be difficult for anyone to understand the problem you are facing without the specific details. People here would like to see the formula you are using and the cells on which you are applying. You may attach screenshots which describe above, or better still, attach the excel file itself in your post (after removing any sensitive or confidential info.)