Hello,

I am trying to calculate the stock inventory of items in my company. I have
imported data from access into excel and attemting to calculate the stock
increase and decrease value.

Eg


CURRENT STOCK = 200
ITEM SHIPPED OUT = 20

CURRENT STOCK = 220

ITEM SHIPPED IN = 100
CURRENT STOCK = 120

It should change according to the qty shipped our or shipped in and should
show current inventory stock for each item in excel.

Can anyone please help with the formula to be used for the same.

thanks in advance.