Formula or code to split stock from warehouse to 2 selling points

[pcloukas]

Good evening,

I would really appreciate a help on this problem

Suppose i have a 50 pieces of an item in my warehouse and i want to send it to 2 selling points.
The one selling point has already 10 pieces and the other 20 pieces.
What formula do i need to give me the solution of having equal (or at least +-1 piece different) to both selling points in order to empty the warehouse.

Here an example

WAREHOUSE	STORE 1	STORE 2		STORE 1 (AFTER EMPTYING WAREHOUSE)	STORE 2 (AFTER EMPTYING WAREHOUSE)
50	10	20		?	?

 

[Alex Blakenburg]

I suspect I am misunderstanding the question but do you just mean something like this ?

Book3
	A	B	C	D	E	F
1	WAREHOUSE	STORE 1	STORE 2		STORE 1 (AFTER EMPTYING WAREHOUSE)	STORE 2 (AFTER EMPTYING WAREHOUSE)
2	50	10	20	Send from Warehouse --->	30	20
3	50	10	20	New Balance --->	40	40
Sheet1

Cell Formulas
Range	Formula
E2:F2	E2	=SUM($A2:$C2)/2-B2
E3:F3	E3	=SUM($A3:$C3)/2

 

[Peter_SSs]

I suspect I am misunderstanding the question but do you just mean something like this ?

I'm also not sure which type of result is wanted (could be both I suppose) but I suspect that that the warehouse items may not be dividable given ..

or at least +-1 piece different

.. so a slight adjustment might be required

22 07 16.xlsm
	A	B	C	D	E	F
1	WAREHOUSE	STORE 1	STORE 2		STORE 1 (AFTER EMPTYING WAREHOUSE)	STORE 2 (AFTER EMPTYING WAREHOUSE)
2	50	11	20	Send from Warehouse --->	29	21
3	50	11	20	New Balance --->	40	41
Split stock

Cell Formulas
Range	Formula
E2	E2	=INT(SUM($A2:$C2)/2-B2)
F2	F2	=A2-E2
E3	E3	=INT(SUM($A3:$C3)/2)
F3	F3	=SUM(A3:C3)-E3