Home

Formula Help

%3CLINGO-SUB%20id%3D%22lingo-sub-821057%22%20slang%3D%22en-US%22%3EFormula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-821057%22%20slang%3D%22en-US%22%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EA%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3EC%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E1%3C%2FP%3E%3C%2FTD%3E%3CTD%3EQTY.%20Bought%3C%2FTD%3E%3CTD%3ERemain%3C%2FTD%3E%3CTD%3ECost%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E2%3C%2FP%3E%3C%2FTD%3E%3CTD%3E10%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E%245%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E3%3C%2FP%3E%3C%2FTD%3E%3CTD%3E10%3C%2FTD%3E%3CTD%3E10%3C%2FTD%3E%3CTD%3E%248%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3EI%20am%20working%20making%20a%20material%20tracking%20sheet%20and%20i%20am%20trying%20to%20find%20a%20way%20for%20a%20cell%20to%20equal%20one%20cost%20until%20the%20remaining%20Value%20becomes%200%20then%20as%20the%20inventory%20is%20is%20pulling%20from%20the%20remaining%20value%20of%20the%20next%20row%20it%20would%20equal%20the%20cost%20equal%20to%20the%20row%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ein%20short%20use%20C2%20until%20B2%20%3D%200%20then%20use%20C3%20until%20B3%20%3D0%20then%20use%20C4%20and%20so%20on%20any%20suggestions%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-821057%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
ryan_love1
Occasional Visitor
 ABC

1

QTY. BoughtRemainCost

2

102$5

3

1010$8

I am working making a material tracking sheet and i am trying to find a way for a cell to equal one cost until the remaining Value becomes 0 then as the inventory is is pulling from the remaining value of the next row it would equal the cost equal to the row 

 

in short use C2 until B2 = 0 then use C3 until B3 =0 then use C4 and so on any suggestions?

Related Conversations