Stock list

[Eddie Wall]

I have a stock list with a "quantity" column.

What I would like to do is add the new stock(A) to the existing
quantity(C) column or subtract requisitioned (B) items from the
quantity column.(C)

I visualised a solution along the lines of Column A is new stock (+)
and Column B is Requisitioned stock (-) and any change in either
would be reflected in column C on a row by row basis for as many rows
as I needed.

Is this possible..

Thanks

Eddie
"But life is short and information endless;
nobody has time for everything" Aldous Huxley

 

[Scoops]

I have a stock list with a "quantity" column.

What I would like to do is add the new stock(A) to the existing
quantity(C) column or subtract requisitioned (B) items from the
quantity column.(C)

I visualised a solution along the lines of Column A is new stock (+)
and Column B is Requisitioned stock (-) and any change in either
would be reflected in column C on a row by row basis for as many rows
as I needed.

Is this possible..

Thanks

Eddie
"But life is short and information endless;
nobody has time for everything" Aldous Huxley

Hi Eddie

If opening stock is in C1 then in C2:

=IF(SUM(A2:B2)=0,"",C1+A2-B2)

Regards

Steve

 

[Eddie Wall]

Thank you Steve,

I slightly modified what you said below.

I have column headers as follows:

A: New Stock
B: Stock Withdrawals
C: Initial / opening stock
D: Current stock. I used the formula =IF(SUM(A2:B2)=0,"",C2+A2-B2) in
the D cells.

It works fine EXCEPT, I cannot add stock a second time. If I input a
number into A it is added to C to get D.... if I input a second
number into A it is added to C to get D... it is not added a second
time as I would wish....

Eddie

Hi Eddie

If opening stock is in C1 then in C2:

=IF(SUM(A2:B2)=0,"",C1+A2-B2)

Regards

Steve

"But life is short and information endless;
nobody has time for everything" Aldous Huxley