How to create special add/subtract formulas?

%3CLINGO-SUB%20id%3D%22lingo-sub-1521701%22%20slang%3D%22en-US%22%3EHow%20to%20create%20special%20add%2Fsubtract%20formulas%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1521701%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20quantities%20sheet.%20where%20I%20receive%20new%20inventory%2C%20shift%20from%20one%20department%20to%20another%2C%20and%20ship%20out.%20I%20currently%20have%20columns%20with%20the%20quantities%20of%20each%20location%20and%20would%20like%20to%20be%20able%20to%20create%20a%20series%20of%20formulas%20that%20allow%20me%20to%20enter%20a%20number%20of%20quantity%20delivered%20or%20shipped%20each%20day%20in%20a%20separate%20cell%2C%26nbsp%3B%20and%20have%20that%20number%20added%20or%20subtracted%20from%20my%20official%20quantity%20automatically.%20I%20do%20not%20know%20how%20to%20set%20this%20up%2C%20as%20I%20only%20want%20to%20have%20to%20enter%20the%20new%20daily%20delta%20in%20a%20cell%2C%20not%20continually%20add%20to%20a%20large%20number.%20How%20could%20I%20make%20the%20cell%20send%20the%20command%20to%20alter%20the%20quantities%2C%20have%20them%20set%20as%20the%20new%20values%2C%20then%20clear%20itself%20and%20ready%20for%20the%20next%20input%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1521701%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1521794%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20create%20special%20add%2Fsubtract%20formulas%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1521794%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F728461%22%20target%3D%22_blank%22%3E%40dannys1430%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20could%20format%20deliveries%20and%20receipts%20of%20products%20in%20a%20table%20and%20calculate%20the%20total%20quantity%20of%20items%20on%20hand%20based%20on%20your%20deliveries%2Freceipts.%20Take%20for%20example%20the%20attached%20workbook.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a quantities sheet. where I receive new inventory, shift from one department to another, and ship out. I currently have columns with the quantities of each location and would like to be able to create a series of formulas that allow me to enter a number of quantity delivered or shipped each day in a separate cell,  and have that number added or subtracted from my official quantity automatically. I do not know how to set this up, as I only want to have to enter the new daily delta in a cell, not continually add to a large number. How could I make the cell send the command to alter the quantities, have them set as the new values, then clear itself and ready for the next input?

1 Reply

Hello @dannys1430,

 

You could format deliveries and receipts of products in a table and calculate the total quantity of items on hand based on your deliveries/receipts. Take for example the attached workbook.