Help with formula, Stock required to be sent as priority

[mattchewie]

Hi all,
i need to create a formula as per the below where you have a store with customer orders in column A, what is in stock in B, what they have soon to arrive at store in C and D is how many they are short.
Column F is what stock is in the warehouse, and waiting to be transferred but due to space i need to prioritize only customer orders. So i need in column H how many i need to send. Keeping in mind that i can't have any more than what is in F, and i only want to fill back orders. So for example row 3 i need to send 3 only. Column 7 i need 5 but there is only 4 available, so i send 4 but raise a new transfer for 1 more.
i'm guessing it's a series of 3 or 4 nested if statements but i can't get it to balance.
I've tried something along the lines of:
=IF(D3=F3,F3,IF(D3>F3,F3,IF(F3<D3,F3-D3,0)))
but it's not working properly

 

[mattchewie]

sorry, i've tried =IF(D3=F3,F3,IF(D3>F3,F3,IF(F3<D3,F3-D3,0))) but its not working for row 6, and i changed row 1 to 10(A) orders, meaning 10 required (D) and 11 in warehouse(F) and it now says send 0(H)

 

[steve the fish]

Hi. Can you copy that and paste it in the forum rather than use a picture.

 

[Fluff]

Also when entering formulae that contain < or > symbols put a space either side of them.
Otherwise the board sees them as HTML code

 

[mattchewie]

Also when entering formulae that contain < or > symbols put a space either side of them.
Otherwise the board sees them as HTML code

Hi, i have had it solved. i was trying several if statements like =IF(D3=F3,F3,IF(D3>F3,F3,IF(F3<D3,F3-D3,0))) but it wasn't working. A friend has told me to use =MIN(D3,MAX(F3,0)) and that has worked so far