Pls help with some AND IF logics.

Hi,
I need to write some logic for the below table.
A few details to understand the req

The First three columns are WH Location
The Value in these columns are excess / short inventory.
If the inventory is shortfall, then the WH that has positive inventory will transfer the required qty.
Eg. If mumbai has -2 qty and banglore has 5, then banglore will transfer 2 qty to mumbai.
Qty transfer should not exceed the qty req.
Qty transfer should not exceed the inventory available.
The below table consist of 3 locations & some same values that needs to be populated in columns 4 - 9



Inventory From Bangalore to From Mumbai to From Delhi to
Mumbai Delhi Bangalore Mumbai Delhi Bangalore Delhi Mumbai Bangalore
0 -1 2 0 1 0 0 0 0
10 4 -14 0 0 10 0 0 4
-1 1 0 0 0 0 0 1 0
-2 6 -3 0 0 0 0 2 3
0 4 4 0 0 0 0 0 0
-7 5 2 2 0 0 0 5 0
-9 5 2 2 0 0 0 5 0
-5 -5 0 0 0 0 0 0 0
-5 -5 1 1 0 0 0 0 0
-5 -5 9 5 4 0 0 0 0
-5 -5 12 5 5 0 0 0 0
5 4 0 0 0 0 0 0 0
5 4 -6 0 0 5 0 0 1
5 4 -11 0 0 5 0 0 4
5 -1 -11 0 0 4 1 0 0
-1 -1 -3 0 0 0 0 0 0
-1 0 -3 0 0 0 0 0 0
-1 -1 0 0 0 0 0 0 0
-1 -1 9 1 1 0 0 0 0
8 -5 -2 0 0 2 5 0 0
11 -1 -7 0 0 7 1 0 0
11 -1 -12 0 0 10 1 0 0
-5 4 1 1 0 0 0 4 0

Request some quick response, pls revert for more clarification.

Regards,
Taran