May 27 2020 10:27 AM - last edited on May 27 2020 01:53 PM by Allen
I need assistance in calculating a Minimum Order Quantity (MoQ) against a Forecast when the Forecast is greater than the MoQ:
For Example:
Cell A1 contains an MoQ of "75": Cell B1 contains a Forecast of "100": Cell C1 contains Order Quantity
Cell A2 contains an MoQ of "150: Cell B2 contains a Forecast of "500": Cell C2 contains Order Quantity
I know that C1 result is 150 and C2 is 600, but I want a flexible formula that calculates this without my having to change it for every cell, since my MoQ's vary.
Anybody with any ideas?
Hopefully this makes sense. Thanks in advance.
May 27 2020 11:19 AM
May 27 2020 12:38 PM
May 27 2020 01:14 PM
May 28 2020 12:45 AM