What Formulas should i use for Adding/subtracting

[dedije]

hello all ..
please help me ..
if I would make a reduction or increase in the last two units of goods making it an excel formula that stock then which one should I use.
example as follows:
1 duz =12 box

	A	B	C	D	E	F	G
1	no.	in		out		stock
2	1	12	9			12	9
3	2				10	11	11
4	3			10	3	?	?
5	4				5	?	?
6

<tbody>
</tbody>

thank you..
dedije

 

[Robert Mika]

hello all ..
please help me ..
if I would make a reduction or increase in the last two units of goods making it an excel formula that stock then which one should I use.
example as follows:
1 duz =12 box

	A	B	C	D	E	F	G
1	no.	in		out		stock
2	1	12	9			12	9
3	2				10	11	11
4	3			10	3	?	?
5	4				5	?	?
6

<TBODY>
</TBODY>

thank you..
dedije

Why the stock is 12 and 9 not 21 in one cell?
And if so why you have got 11 under 9 as well?

 

[dedije]

Why the stock is 12 and 9 not 21 in one cell?
And if so why you have got 11 under 9 as well?

thanks for the reply Robert,
12 means 12 duz (B, D, F) while 9 means pack (C, E, G)
Added: 12 duz 9 pack
then
out: 10 pack
stock into: 11 duz 11 packs


regards
dedije

 

[Robert Mika]

thanks for the reply Robert,
12 means 12 duz (B, D, F) while 9 means pack (C, E, G)
Added: 12 duz 9 pack
then
out: 10 pack
stock into: 11 duz 11 packs


regards
dedije

With Helper column H
H2:=F2*12+G2
F3 down
=INT(H3/12)
G3 down:
=H3-(F3*12)

H3 down:
=((B3*12)+C3)+H2-((D3*12)+E3)