05-27-2020 10:27 AM - last edited on 05-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:
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.