SOLVED

Math functions

%3CLINGO-SUB%20id%3D%22lingo-sub-2120768%22%20slang%3D%22en-US%22%3EMath%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2120768%22%20slang%3D%22en-US%22%3E%3CP%3EWhat%20is%20the%20proper%20function%20to%20subtract%20cells%3F%20Below%20are%20the%20instructions%20and%20excel%20spreadsheet.%20I%20needed%20clarification%20for%20step%2012%20on%20the%20word%20document.%20I%20have%20been%20using%20the%20function%20%3DSUM(B11-B21)%2C%20my%20numbers%20are%20obviously%20coming%20out%20negative%20because%20B11%20is%20a%20larger%20quantity.%20The%20final%20product%20on%20the%20word%20document%20does%20not%20show%20any%20negatives.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2120768%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-2121885%22%20slang%3D%22en-US%22%3ERe%3A%20Math%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2121885%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F675152%22%20target%3D%22_blank%22%3E%40JMB17%3C%2FA%3E%26nbsp%3BThank%20you!%20I%20appreciate%20the%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2120813%22%20slang%3D%22en-US%22%3ERe%3A%20Math%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2120813%22%20slang%3D%22en-US%22%3EYou%20just%20have%20them%20interchanged.%20Also%2C%20you%20shouldn't%20need%20the%20sum%20function%3CBR%20%2F%3E%3CBR%20%2F%3E%3DB21-B11%3C%2FLINGO-BODY%3E
New Contributor

What is the proper function to subtract cells? Below are the instructions and excel spreadsheet. I needed clarification for step 12 on the word document. I have been using the function =SUM(B11-B21), my numbers are obviously coming out negative because B11 is a larger quantity. The final product on the word document does not show any negatives. 

2 Replies
best response confirmed by karolineaquino (New Contributor)
Solution
You just have them interchanged. Also, you shouldn't need the sum function

=B21-B11

@JMB17 Thank you! I appreciate the help.