Hi

I made a hash of that didn't I!!!

D2 should have been
=IF(COUNT(B2:C2)<1,"",A2+B2-C2)

A3 should be =D2
D3 should be =IF(COUNT(B3:C3)<1,"",A3+B3-C3)
Copy A3:D3 down the page as far as required

--
Regards

Roger Govier


"vandy" wrote in message
...
Hello Roger,

The current stock does not show the correct value after 3 to 4 entries
of
out and in.

Does D2 hold the current stock now.


for eg. Current stock is 100
A B C D
opening stock in out current stock

100 80 0 180

0 20 160

40 0 140
I GET THIS RESULT WHEN I ENTER THE VALUE IN AS 40. I SHOULD BE GETTING
160+40 = 200 AS AGAINST 140 SINCE ITS ADDING THE CURRENT VALUE OF
OPENING
STOCK 100.

The current stock has to keep the updated value of opening stock after
every
transaction i dont believe this is happening.

KINDLY ADVISE .
THANKS A TON.
VANDY
shipped out
"Roger Govier" wrote:

Hi

assuming that all data is entered as positive values, and with
A1 =Opening stock
B1 =Shipped Out
C1 =Shipped In
D1 =Current Stock

In D2
=A1-B1+C1

--
Regards

Roger Govier


"vandy" wrote in message
...
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.