Calculating MoQ Against a Forecasted Demand

[df_knapp]

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.

[#2]

@df_knapp 

Hi,

=CEILING(B1/A1,1)*A1

Regards

[#3]

Hi @Jos_Woolley 

It worked!

Thank you for the response and the solution, Jos.

Dan

[#4]

@Jos_Woolley 

This can be simplified a little to read

= CEILING(Forecast, MoQ)

[#5]

@df_knapp 

You're very welcome!