Dear Everyone,
I am in a jam right now, been banging my head in my desk but still haven't figure it out yet. May I request for you help in the attached sheet please, the logic I am trying to complete are as follow;
Version 1
- If remaining inventory (L10) is greater than Quantity to order (Q10) then the outcome should be a text that says "DONT ORDER"
- If remaining inventory (L10) is less than Quantity to order (Q10) then the outcome should be a text that says "ORDER"
Version 2
- If remaining inventory (L10) is greater than Quantity to order (Q10) by 20% then the outcome should be a text that says "DONT ORDER"
- If remaining inventory (L10) is less than Quantity to order (Q10) by 20% then the outcome should be a text that says "ORDER"
If anyone could give me a quick logic on the greater than less than conditional formula would be great as well on the side.
Really appreciate you help my friend, thank you very much!
Regards,
Francis
Bookmarks