labjr1231 Wrote:
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 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 Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=402021