Pulling Values to zero using multiple cells

%3CLINGO-SUB%20id%3D%22lingo-sub-2194855%22%20slang%3D%22en-US%22%3EPulling%20Values%20to%20zero%20using%20multiple%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2194855%22%20slang%3D%22en-US%22%3EI%E2%80%99m%20trying%20to%20pull%20numbers%20down%20to%20zero%20using%20multiple%20cells.%20So%20if%20I%20have%2050%20in%20cell%201%20and%2050%20in%20cell%202%2C%20how%20do%20I%20get%20excel%20to%20pull%20the%2050%20in%20cell%201%20down%20to%200%20first%20before%20starting%20to%20pull%20the%2050%20from%20cell%202%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2194855%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2195150%22%20slang%3D%22en-US%22%3ERe%3A%20Pulling%20Values%20to%20zero%20using%20multiple%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2195150%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F991238%22%20target%3D%22_blank%22%3E%40Force1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20want%20Running%20Subtraction%20is%20same%20column%20then%20you%20have%20to%20use%20VBA%20macro%2C%20otherwise%20you%20need%20simple%20formula%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Rajesh-S_0-1615271737387.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F261880i742E6703D1B5EFD6%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Rajesh-S_0-1615271737387.png%22%20alt%3D%22Rajesh-S_0-1615271737387.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3EFormula%20in%20cell%20AA1%3A%26nbsp%3B%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3DZ1%3C%2FP%3E%3CUL%3E%3CLI%3EFormula%20in%20cell%20AA2%3A%26nbsp%3B%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3DIF(ISBLANK(Z2)%2C%22No%20Value%22%2CSUM(Z2-AA1))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3EAdjust%20cell%20references%20in%20the%20formula%20as%20needed.%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
I’m trying to pull numbers down to zero using multiple cells. So if I have 50 in cell 1 and 50 in cell 2, how do I get excel to pull the 50 in cell 1 down to 0 first before starting to pull the 50 from cell 2
2 Replies

@Force1 

If you want Running Subtraction is same column then you have to use VBA macro, otherwise you need simple formula:

 

Rajesh-S_0-1615271737387.png

 

  • Formula in cell AA1: 

         =Z1

  • Formula in cell AA2: 

         =IF(ISBLANK(Z2),"No Value",SUM(Z2-AA1))

 

  • Adjust cell references in the formula as needed.

 

Thank you for that! So if I have 10,000lbs product and I want to split them into 5,000lb /cell because the first 5,000 lbs of product has an earlier expiration date therefore needs to be used up first from inventory but still need to keep track of total inventory. So I’m hoping to pull the 5,000 lbs in cell 1 down to 0 before it starts pulling the 5,000 lbs from cell 2 but always keeping my current inventory visible. Hope this messes sense!