A problem with modifying formula for repeating a function every nth row!

[Arty_1]

Hello!

There is a little issue concerning modifying formula for repeating a function every 14th row.

The function does the same calculations every 14th row but the result decreases by 5 every time.

I have added the xlsx file with more detailed description of the problem.

Would you be so kind to give the matter a reasonable consideration.

Thanks in advance

Lebedev A.

[gak67]

The problem is not your formula. Inventory decreases by 5 each day. Over 14 days that's 70 units. You are only replenishing with 65 units every 14 days. You are going to run out. You need to increase your Q_ord to 70 or reduce your replenish cycle to 13 days.

The reason it looks like it works the first cycle is that from day 1 to day 14 inclusive is 14 days, but from day 14 to day 28 inclusive is 15 days.

[Arty_1]

Simple as that!

Thank you!

Regards

Lebedev A