Help need creating a formula.

[crazy_papaya]

Hello all,

I am trying to put it all in one formula together but failing. It might be easier for you i think, please see if you can assist me -

1) H2 should be equal to C2 but if G2 is less than C2 then H2 should G2
2) If H2 is in negative then it should be either "0" or " No transfer required "

Drug Code	Current Stock	Required	Transfer From	Remaining Stock	Transfer Amount
DR0012	10​	30​	DR0033	20​	20
DR0013	5​	24​	DR0034	66​
DR0014	0​	40​	DR0035	3​
DR0015	20​	60​	DR0036	-75​

 

[crazy_papaya]

Ok, i'll need to think deeply on this...
I'll get back to you

(Sorry! Not the best person with this logic stuff. I just follow managers order :P)

 

[crazy_papaya]

Fluff, at the end of my deep thinking exercise I was able to create the formula myself -

=IF(I3<N3,"Insufficient Stock",IF(N3<=0,"Stock Available",MIN(I3,N3)))

Of course this was created based off all the formulas you have helped build so far so big thanks to you ?

 

[Fluff]

Glad you sorted it & thanks for the feedback.