simple stock control (Excel 2003 & 2007)

[steveh]

Morning all

Stupid question of the day, say I have 3 columns, A, B and C

Column A Stock in
Column B stock out
Column C running total

Column A will only have updates 2 or 3 times a month, Column B may have daily stock out and I need Column C to show the current balance. If I enter =A2-B2, C2 will show the right result but if I drag C2 down abd then enter a figure in B3 it shows the wrong answer. I have attached a very simple example TIA

[rory]

Wouldn't C3 need to be:
=C2+A3-B3
and then copy that down?

[steveh]

Wouldn't C3 need to be:
=C2+A3-B3
and then copy that down?

Thanks Rory

I just could not get it this morning, can I add anything so that when I drag it down column c is blank until another quantity is put in the djacent b column?

[HansV]

If you'll fill in columns A and B from top to bottom, you could enter

=IF(AND(A3="",B3=""),"",C2+A3-B3)

in C3 and fill down. This will fail, however, if you leave a row blank in columns A and B, then enter something in a row below:

x127.png

[steveh]

If you'll fill in columns A and B from top to bottom, you could enter

=IF(AND(A3="",B3=""),"",C2+A3-B3)

in C3 and fill down. This will fail, however, if you leave a row blank in columns A and B, then enter something in a row below:

Cheers Hans

That worked like a charm