Forum Discussion
Inventory Formula
BEG. INV (CTN,BDL) BEG. INV (BAG,PCS) REMAINING (CTN,BDL) REMAINING (BAG,PCS) 27 15 27 -3 Hi I was wondering if what formula to use or if there is any for what I want to happen ...
Thanks. Is there an alternative formula that I can use? I don't have hstack on my excel.
In D2:
=QUOTIENT(G2*A2+B2-C2-1, G2)
In E2:
=MOD(G2*A2+B2-C2-1, G2)+1