SOLVED

Inventory / stock checking discrepancy

%3CLINGO-SUB%20id%3D%22lingo-sub-2574639%22%20slang%3D%22en-US%22%3EInventory%20%2F%20stock%20checking%20discrepancy%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2574639%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%26nbsp%3B%20I%20have%20done%20a%20stock%20check%20and%20would%20like%20to%20see%20the%20positive%20and%20negative%20quantities%20and%20costs.%26nbsp%3B%20I%20don't%20know%20what%20formula%20I%20should%20use.%26nbsp%3B%20The%20physical%20count%20of%20the%20stock%20is%20column%20D%20and%20the%20stock%20that%20our%20system%20shows%20is%20column%20E.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2574639%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-2574706%22%20slang%3D%22en-US%22%3ERe%3A%20Inventory%20%2F%20stock%20checking%20discrepancy%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2574706%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1032615%22%20target%3D%22_blank%22%3E%40helsbrooks1981%3C%2FA%3E%26nbsp%3BAdded%20some%20formulae%20in%20I%20and%20J.%20Is%20that%20what%20you%20had%20in%20mind%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2574745%22%20slang%3D%22en-US%22%3ERe%3A%20Inventory%20%2F%20stock%20checking%20discrepancy%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2574745%22%20slang%3D%22en-US%22%3EHi%20there%20-%20thats%20right%20I'm%20looking%20for%20a%20formulae%20in%20I%20and%20J%20to%20show%20if%20there%20is%20a%20positive%20order%20negative%20amount%20and%20value%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2574746%22%20slang%3D%22en-US%22%3ERe%3A%20Inventory%20%2F%20stock%20checking%20discrepancy%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2574746%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1032615%22%20target%3D%22_blank%22%3E%40helsbrooks1981%3C%2FA%3E%26nbsp%3Band%20you%20noticed%20the%20file%20I%20attached%20with%20the%20formulae%20in%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello.  I have done a stock check and would like to see the positive and negative quantities and costs.  I don't know what formula I should use.  The physical count of the stock is column D and the stock that our system shows is column E.  

6 Replies

@helsbrooks1981 Added some formulae in I and J. Is that what you had in mind?

best response confirmed by helsbrooks1981 (Occasional Contributor)
Solution
Hi there - thats right I'm looking for a formulae in I and J to show if there is a positive order negative amount and value

@helsbrooks1981 and you noticed the file I attached with the formulae in it?

That works thank you. Except when saving to Sharepoint I get an error with the formula in column J it says #VALUE! and it says "a value used in the formula is the wrong data type"

@helsbrooks1981 Know nothing about Sharepoint. Sorry! I copied the format from column G. 

@helsbrooks1981 

And if before saving on Sharepoint convert it to xlsx format?