crazy_papaya
New Member
- Joined
- Feb 10, 2020
- Messages
- 28
- Office Version
- 2016
- Platform
- Windows
- Web
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 "
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 |