I am new to formulas. I would like to run an inventory. 3 columns, A1
recieve,B1 Shipped, C1 Balance.
I want C1 to give total weither I place a number in A1 or B1.
Thanks
I am new to formulas. I would like to run an inventory. 3 columns, A1
recieve,B1 Shipped, C1 Balance.
I want C1 to give total weither I place a number in A1 or B1.
Thanks
Hi labjr1231Originally Posted by labjr1231
with the info you have given try in C2 =A1-B1
However to keep your inventory balance you will surely need a column for Opening Stock?
In which case if Opening Stock was in A1, recieve B1 Shipped C1 and Balance D1, try in D2 =A1+B1-C1
Paul
There are currently 3 users browsing this thread. (0 members and 3 guests)
Bookmarks