Order formula

[texsa]

Hi there I need help on the following formula

J3 is the stock level(Actual)
M3 is Max stock hold
N3 is Min stock
K3 is what should be ordered after a stock count. But I would like to automate the formula.

If J3 is equal to or less than N3 then J3 less M3 is equal to K3

 

[Lewiy]

=IF(J3<=N3,M3-J3,0)

I have assumed that you meant M3 less J3 is equal to K3, otherwise you'd be ordering negative stock all the time

 

[texsa]

Order Formula

Ok thanks for the help.
Sorry I got it the formula wrong way around but at least you understood what I was asking